| Oracle 9i Explian Plan output- TOAD [message #115110] |
Thu, 07 April 2005 09:17  |
kumarsz
Messages: 180
Registered: March 2005
Location: canada
|
Senior Member |
|
|
Hi
given here is an Explain Plan output in TOAD - for a sql query.
I want to know what is the parameter 'cost' here?
Does it show seconds, milliseconds, nanoseconds or it is just a comparative parameter to be used to copmare with other Explain Plan output for the same query.
Thanks in Advance
Pratap
|
|
|
|
| Re: Oracle 9i Explian Plan output- TOAD [message #115111 is a reply to message #115110] |
Thu, 07 April 2005 09:28  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
seems your attachment of explain plan didNOT go through.
Anyhow,
COSTS within a query plan is useless. It is just derived number
The optimizer computes many criterions in many phases to come with this cost,
and uses the plan with the lowest cost.
But it doesnt mean that a plan with higher cost is bad or a plan with lower cost is better.
the tunining manual deals with this extensively.
[Updated on: Thu, 07 April 2005 09:28] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
