Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: A Sort Problem ( ADABAS fatser than Oracle )
Klaus Engel schrieb in Nachricht <3523B683.B213B1A8_at_raie.de>...
>It seems that your query doesn't take advantage of your index. There is a
tuning
>
>rule in the documentation saying that the left most index of a composite
index
>needs
>to be mentioned in the where statement in order to force the query to make
use
>of the index.
>Alternatively using the INDEX hint might also help.
>
>Sorting (without using a sorted) can affected when sorting is done to
memory
>rather than to disk.
>This can be affected by the sort_area_size parameter in the initSID.ora
file.
>
>
I doesn't take advantage of my index because I looked at the explain plan of the statement after I set sql_trace = true. And I incerase the parameter sort_area_size but it has no affect. Received on Fri Apr 03 1998 - 00:00:00 CST