• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 527
  • Last Modified:

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.
0
snoor07
Asked:
snoor07
2 Solutions
 
Steve WalesSenior 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) 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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now