How to interpret explain plan [message #303396] |
Fri, 29 February 2008 02:58  |
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.
|
|
|
|
|