Re: How can I further reduce physical read for this query short of throwing memory at it?

Home -> Community -> Usenet -> c.d.o.server -> Re: How can I further reduce physical read for this query short of throwing memory at it?

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 14 Feb 2006 20:15:17 +0100
Message-ID: <dst9gv$fgg$1@news4.zwoll1.ov.home.nl>

xhoster_at_gmail.com wrote:
> Frank van Bortel <frank.van.bortel_at_gmail.com> wrote:

>> Why is the ORG table parallel? 70k rows might be better
>> off non-parallel.

>
> Doesn't ORG have to be accessed in parallel if it is going to be used
> to drive a parallel NL on SALES?
>

Xho, I wouldn't know, but you might have a point there.

The issue at hand is, that certain platforms are lousy in parallel queries; it might simply be faster to execute all or a part non-parallel.
And some combinations are simply buggy, but the OP did not state version or platform

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Tue Feb 14 2006 - 13:15:17 CST