Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance with ORDER BY !!!
maybe add an index on the column you order
Franz Mueller <nospam#####franz.mueller_at_orbis.de> a écrit dans le message :
3843c9ad.19356322_at_news.salink.net...
> 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?
Received on Tue Nov 30 1999 - 07:38:09 CST