Re: Plan_table cost column units

  • From: Tim Johnston <tjohnston@xxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 11 Mar 2004 20:19:51 -0500

Jacques Kilchoer wrote:

The execution plan with the smallest total cost will also be the execution plan that runs fastest due to the excellence of the algorithm used by the Oracle database engine.



Um... I hate blanket statements like that... I can think of too many exceptions... Like, assuming the the optimizer has accurate statistics to properly evaluate the statement...

--
Regards,
Tim Johnston
Tel: 978-322-4226
Fax: 978-322-4100


---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------

Other related posts: