Re: Re: anyone ever use sub-partitioning?

  • From: <ryan.gaffuri@xxxxxxx>
  • To: "Michael McMullen" <ganstadba@xxxxxxxxxxx>,<oracle-l@xxxxxxxxxxxxx>, <ryan.gaffuri@xxxxxxx>
  • Date: Fri, 30 Apr 2004 11:06:55 -0400

We are going to partition on our primary key. The only reason for partitioning 
is to load deltas. We want to take advantage of parallel DML.

If we partition on the primary key to maintain data integrity we need to use a 
global index right? If we want to use parallel dml we have to use local 
indexes. So my only option is to use both right? 

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: