Re: Performance when using ORDER BY

This is a result of that you have to complete the query otherwise there is no way of sorting it. Imagine starting to output after 50% of the query. What would you do with the unsorted 50 %.

I suppose since you are new there are a lot to learn about indexes. Sorting and outputing your result on a table of 90,000 rows shouldn't take many seconds.

So go through your joins if you have any and index them. Steve Rafferty wrote in message <6e6bl4$oum$1_at_list.umaryland.edu>...
>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 Thu Mar 12 1998 - 00:00:00 CST