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 -> Performance with ORDER BY !!!

Performance with ORDER BY !!!

From: Franz Mueller <nospam#####franz.mueller_at_orbis.de>
Date: Tue, 30 Nov 1999 13:01:03 GMT
Message-ID: <3843c9ad.19356322@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:01:03 CST












Original text of this message













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