Re: Performance with ORDER BY !!!

you can query v$sqlarea and see if your order by query does disk sorts, if it does you might want to increase your sort_area_size, or make sure your initial extent in TEMP is bigger then sort_area_size.

On Tue, 30 Nov 1999 13:01:03 GMT, nospam#####franz.mueller_at_orbis.de (Franz Mueller) wrote:

>If I have a query that returns, say 500 rows. I have good indices on
>the WHERE clauses and the answer time is OK. The problem is that in
>practice you always want to show the results sorted (alphabetically).
>If you add ORDER BY <something> the performance descreases
>dramatically. What can be done?

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email