Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help improving the performance of a query - please

Re: Help improving the performance of a query - please

From: <JOC>
Date: Wed, 01 Dec 1999 10:26:21 GMT
Message-ID: <3844f795.1869943@NEWS>


On Tue, 30 Nov 1999 20:08:44 +0100, "Sybrand Bakker" <postmaster_at_sybrandb.demon.nl> wrote:

>The execution path is already optimal, as the biggest table is retrieved
>last.
>The only thing you could do is try to optimise the order by:
>check out whether this is a disk sort or not, increase sort_area_size and
>the like.
>
>Hth,
>
>--
>Sybrand Bakker, Oracle DBA

Thanks - that was what I thought - I just hoped I was having a thick day. Ho hum.

        Jo


The usual - anything I say reflects on me, and not upon my current employer.


Received on Wed Dec 01 1999 - 04:26:21 CST

Original text of this message

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