| Explain Plan [message #397810] |
Tue, 14 April 2009 00:52  |
vinniora
Messages: 56
Registered: October 2008
Location: Mumbai
|
Member |
|
|
Hello everyone, i want to know about the explain plan.When i execute the query explain plan for select * from dual
and then execute select * from table(dbms_xplan.display)
then we got a structure so in this concern i would like to know what is the meaning of column 'cost(%cpu)' that is what is the measure of cost,how it is calculated and what is in the bracket(%cpu) what does this means to us and how it is measured ,also tell about which value among them to be remain as less possible for best execution plan.thnx in advance..
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
