Using Explain Plan to check Mysql query performance

Reply
Highlighted
Orange Belt

Using Explain Plan to check Mysql query performance

Hi,

 

I am trying to run Explain plan on my queries to check query performance.

When I use the SQL transform I get a message saying the statement is valid but it does not show any output. When I use the Table transform it throws an error saying it needs to be a SELECT statement.

So I was wondering is there any alternate way to check query performance in MySQL dataflows?

 

Thanks,

Prajwal


Accepted Solutions
Orange Belt

Re: Using Explain Plan to check Mysql query performance

Never mind, I found it. 

I did not realize there was an option to Run Explain Plan in the transforms.

 

View solution in original post


All Replies
Orange Belt

Re: Using Explain Plan to check Mysql query performance

Never mind, I found it. 

I did not realize there was an option to Run Explain Plan in the transforms.

 

View solution in original post

Announcements
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!