Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help improving the performance of a query - please
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.
![]() |
![]() |