Performance when using ORDER BY

From: Steve Rafferty <sraffert_at_umabnet.umab.edu>
Date: 1998/03/11
Message-ID: <6e6bl4$oum$1@list.umaryland.edu>#1/1

Hello all --

I'm new to Oracle (and to databases in general). I've created a web based application which searches a database of 90,000 records and displays the results. A basic query executes very quickly -- records begin displaying in approx 3 seconds; however, I want to sort the output on two columns. When I add

ORDER BY COLUMN1 ASC, COLUMN2 DESC the first results of a query appear 30 - 60 seconds after the query is submitted.

I understand that without the ORDER BY clause the results of the query are being displayed while the query is still being executed. My question is: is there a way to achieve the output sort I want without the devastating performance loss?

Thanks,

Steve Received on Wed Mar 11 1998 - 00:00:00 CST