Re: Performance with ORDER BY !!!

Create an index on the column order you need and use an index_asc() hint. The rows will be returned in index order.

D.

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?
Received on Sun Dec 05 1999 - 11:07:48 CST