Re: ORDER BY performance problem

How do you check that? tkprof?

Jason Salter wrote:

> 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:53:58 CDT