Skip to content

    • Magic ETL

    Magic ETL

    Using Explain Plan to check Mysql query performance

    Member
    in Magic ETL

    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

    Best Answer

    • Member
      Answer ✓

      Never mind, I found it. 

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

       

    Answers

    • Member
      Answer ✓

      Never mind, I found it. 

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

       

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories