Re: best way to invoke parallel in DW loads?

  • From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
  • To: Herring Dave - dherri <Dave.Herring@xxxxxxxxxx>
  • Date: Wed, 16 Sep 2009 11:38:41 -0700

I'm quite certain that with 9.1 any restrictions on doing PDML on a
single segment were removed and certainly in 10.1 PDML works on a
single segment by doing granule based PDML vs segment based.  Perhaps
the documentation is incorrect.

On Wed, Sep 16, 2009 at 9:04 AM, Herring Dave - dherri
<Dave.Herring@xxxxxxxxxx> wrote:
> But, for UPDATEs and DELETEs, your main gain with
> parallel DML is with partitioned objects.  At least that was the case in
> 9i, as I believe the doc explicitly listed this (of course my quick
> check didn't confirm this, so may be full of it).


-- 
Regards,
Greg Rahn
http://structureddata.org
--
//www.freelists.org/webpage/oracle-l


Other related posts: