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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Why does Optimizer relys on COST to produce the execution plan?

RE: Why does Optimizer relys on COST to produce the execution plan?

From: <oracle-l-bounce_at_freelists.org>
Date: 2006-01-02 11:28:47
Message-id: F2C9CCA71510B442AF71446CAE8AEBAF205684@MSXVS04.trivadis.com

>If you give a look to the figures of your query, the cost of the index scan and the LIO \
performed
>to execute it are quite close. The problem, probably, is that the FTS are too highly \
cost.
>(db_file_multiblock_read_count too large?)

Sorry, first typo of the year... "too highly cost" should be "too weakly cost".

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 02 2006 - 11:28:47 CST

Original text of this message

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