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 -> Re: ORDER BY performance problem

Re: ORDER BY performance problem

From: Jason Salter <jason_at_seahorse.demon.co.uk>
Date: Mon, 09 Aug 1999 16:24:09 GMT
Message-ID: <37af0066.27126967@news.demon.co.uk>


You could check to see if the query is sorting to disk or within memory.

Regards,
Jason.

On Mon, 09 Aug 1999 13:43:50 GMT, franz.mueller_at_orbis.de (Franz Mueller) wrote:

>Hi,
>
>I have a performance problem with a query that ends with "ORDER BY .."
>Without the ORDER BY it runs really fast. The difference is really big
>(on an answer set with 200 rows). Is there a way to speed up this kind
>of query?
>
>Franz
Received on Mon Aug 09 1999 - 11:24:09 CDT

Original text of this message

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