Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORDER BY performance problem
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
![]() |
![]() |