2 Replies Latest reply on Nov 22, 2016 9:14 PM by rp0428

    SQL Developer Explain Plan Documentation

    user540230

      Hello:

      Could someone please direct me to a GOOD article on SQL Developer's Explain plan.  The documentation in the main Oracle documentation doesn't even use the same column names as what SQL Developer renders, and it doesn't explain how to use it to modify SQL queries.  There is literally nothing I could find anywhere that really explains HOW to use it to tune a SQL statement.  Being new to the tuning environment, I need something that goes step by step in explaining how to interpret the plan as a guide to modifying the SQL statements.

       

      Thanks,

       

      Kim