Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: A Sort Problem ( ADABAS fatser than Oracle )

Re: A Sort Problem ( ADABAS fatser than Oracle )

From: Andreas Walter <a.walter_at_dr-staedtler.de>
Date: 1998/04/03
Message-ID: <6g2c6b$a7q$1@news.nacamar.de>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US