Which plan is better - what COST really means ?

From: "Prem Khanna J" <premj@xxxxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: 13 Jan 2005 08:57:11 -0000

Friends,
when i have got two plans , how do i decide 
which one is the best ?

just read in asktom , that COST of a plan , 
does not have any correspondence with response
time of a query.

i.e.,a query with higher COST than another
 can be faster.

if so , what in the execution plan does help 
me to decide about a good (faster) plan ? 

unless i execute it , can't i know it ? 
is that the only way !!!

Can someone throw light on this ?
The environment is oracle 9.2.0.4/AIX5.2L.

Thanks in advance.

Regards,
Prem.
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: Which plan is better - what COST really means ?
From: Jaffar_DBA

Re: Which plan is better - what COST really means ?
From: J . Velikanovs

Re: Which plan is better - what COST really means ?
From: Giovanni Cuccu

Re: Which plan is better - what COST really means ?
From: Connor McDonald

Which plan is better - what COST really means ?

Other related posts: