1 Reply Latest reply: Apr 2, 2013 5:29 PM by Gary Graham-Oracle RSS

    SQL Tuning Advisor

    jrgwv55
      When using SQL Tuning Advisor in SQL Developer, I have two questions one is there a way to export or save the results in the detail tab?

      Second, when there is a recommendation for example it states found at line 18 of the execution plan, and looking at the execution plan it has the operation MERGE JOIN OUTER listed, in the tuning advisor counting from the bottom of the joins or is it counting from the top ?

      I am trying to identify which line of SQL Code corresponds to line 18 in the execution plan.
        • 1. Re: SQL Tuning Advisor
          Gary Graham-Oracle
          Hi,
          is there a way to export or save the results in the detail tab
          No save or export options exist. You can only highlight the text, then copy (Ctrl-c) and paste (Ctrl-v).
          I am trying to identify which line of SQL Code corresponds to line 18 in the execution plan
          In the worksheet, right-click in the left gutter column, then select Toggle Line Numbers -- line numbers will appear in the worksheet's left gutter as well as the SQL text in the Tuning Advisor Overview tab.

          Hope this helps,
          Gary