Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Cost Based Optimizer - Chooses slowest plan?
I'm running a 7.3.4 database in choose mode. At one point the optimizer
chose to use indexes for my sql which
I know executes faster than doing a full table scan. I've actully seen
the performance degredation when I run it
with out using the indexes. Now its chose not to use indexes. The cost
for the sql using the index is actually higher than the sql not using
the index
even though the sql using the index is faster. I thought the fastest
sql would also have the lowest cost? I've analyzed
the tables and indexes in question, so the statistics are there. Are
there problems with the optimizer in 7.3.4? Are there
additional parameters that need to be set for the optimizer to choose a
better(faster) plan?
TIA Received on Mon Aug 23 1999 - 16:52:15 CDT