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: Doug Cowles <dcowles_at_bigfoot.com>
Date: Mon, 09 Aug 1999 12:53:58 -0400
Message-ID: <37AF07A6.5EDB66E3@bigfoot.com>


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

Original text of this message

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