Re: Performance with ORDER BY !!!

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 30 Nov 1999 20:12:13 -0000
Message-ID: <943993295.17732.0.nnrp-09.9e984b29@news.demon.co.uk>

It's very hard to make any sensible response if you don't quantify things like 'time is OK' and 'decreases dramatically'. A hint about the environment would help too.

e.g.
Does 'time is okay' mean you see the first screen full within a second on an OLTP
system, and does adding an ORDER BY
drop this to 3 seconds or 1 minute ?

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Franz Mueller wrote in 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 - 14:12:13 CST