Read Explain Plan table in Oracle

How to analyze  explain plan table for sql tuning ? I am not clear idea about it. Please let me know.
snoor07Asked:
Who is Participating?
 
Steve WalesConnect With a Mentor Senior Database AdministratorCommented:
There's a lengthy article here that talks about a lot of what you'll see:
http://www.akadia.com/services/ora_interpreting_explain_plan.html

You can use DBMS_XPLAN to pretty up the output of the PLAN_TABLE (which helps make it easier to understand):
http://www.oracle-base.com/articles/9i/dbms_xplan.php

They would be two places to start reading to get an overview of what you're seeing, to start with.
0
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
I suggest you start with the online docs:
http://docs.oracle.com/cd/E11882_01/server.112/e16638/ex_plan.htm#PFGRF009

If you have specific questions after reviewing the docs, just ask.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.