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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re: anyone ever use sub-partitioning?

Re: Re: anyone ever use sub-partitioning?

From: <ryan.gaffuri_at_cox.net>
Date: Fri, 30 Apr 2004 11:06:55 -0400
Message-Id: <20040430150654.FNWG18803.lakermmtao11.cox.net@smtp.central.cox.net>


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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Fri Apr 30 2004 - 10:05:53 CDT

Original text of this message

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