Home » SQL & PL/SQL » SQL & PL/SQL » How to interpret explain plan
How to interpret explain plan [message #303396] Fri, 29 February 2008 02:58 Go to next message
beetel
Messages: 96
Registered: April 2007
Member
I would like to know how to interpret explain plans. I mean which entries may reduce the cost or add to the cost, which are harmful or should be avoided, how to interpret which joins are efficient.. how should i be able to read explain plans and the same time judge if it is optimal or can be further improved... you may send me the links too. That would be helpful. Most of the articles in the web talk about what it is, what it does but not really on how to use read it efficiently...thanks in advance.
Re: How to interpret explain plan [message #303399 is a reply to message #303396] Fri, 29 February 2008 03:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64118
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Performance Tuning Guide
Chapter 19 Using EXPLAIN PLAN

Regards
Michel
Re: How to interpret explain plan [message #303580 is a reply to message #303399] Fri, 29 February 2008 21:10 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Understanding Explain Plan

Ross Leishman
Previous Topic: small problem with this query
Next Topic: Performing DML operations on Pipelined functions
Goto Forum:
  


Current Time: Tue Dec 06 04:55:07 CST 2016

Total time taken to generate the page: 0.20890 seconds