Re: index

From: David Fitzjarrell <fitzjarrell_at_cox.net>
Date: 30 Jul 2004 09:27:42 -0700
Message-ID: <9711ade0.0407300827.33bd37f6@posting.google.com>

"dead" <OVOIZBACI-vlasic_at_vodatel.net> wrote in message news:<cecro0$51n$1_at_sunce.iskon.hr>...
> sort area size was 65536
> and I change it to 131072
> but resurts are same after restart
> results of query are :
> sorts (memory) 4229
> sorts (disk) 2
> sorts (rows) 1601626

Use 524288 as a value. Then restart your instance. You should see improvement.

David Fitzjarrell Received on Fri Jul 30 2004 - 11:27:42 CDT