Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to 'force' optimizer to use indexes?
You request the query results to be sorted by the indexed column, which
is why it chooses the index. The question is why doesn't it choose the
index in your 8.0.5 box? There could be a few reasons:
- check your SORT_AREA_SIZE, the higher it is, the less the cost of
sorting is, as perceived by the Oracle optimizer;
- make sure that you ran the stats on the table and that they reflect
the true state of the data, especially the number of rows in the table.
Kirill
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Mar 31 2000 - 00:00:00 CST