Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Why does Optimizer relys on COST to produce the execution plan?
>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-lReceived on Mon Jan 02 2006 - 11:28:47 CST
![]() |
![]() |