Re: A Sort Problem ( ADABAS fatser than Oracle )

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. Received on Thu Apr 02 1998 - 00:00:00 CST