Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Which plan is better - what COST really means ?

Which plan is better - what COST really means ?

From: Prem Khanna J <premj_at_rediffmail.com>
Date: 13 Jan 2005 08:57:11 -0000
Message-ID: <20050113085711.17911.qmail@webmail6.rediffmail.com>


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
Received on Thu Jan 13 2005 - 02:50:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US