Read Explain Plan table in Oracle

Posted on 2013-01-08
Medium Priority
Last Modified: 2013-01-12
How to analyze  explain plan table for sql tuning ? I am not clear idea about it. Please let me know.
Question by:snoor07
LVL 23

Accepted Solution

Steve Wales earned 750 total points
ID: 38756324
There's a lengthy article here that talks about a lot of what you'll see:

You can use DBMS_XPLAN to pretty up the output of the PLAN_TABLE (which helps make it easier to understand):

They would be two places to start reading to get an overview of what you're seeing, to start with.
LVL 78

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 750 total points
ID: 38756326
I suggest you start with the online docs:

If you have specific questions after reviewing the docs, just ask.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question