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
Highlighted
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
Highlighted
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
What is your Dojo rank and what badges have you earned? How am I doing? Get a refresher on how to up your rank and collect badges in the Dojo here.