Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re: anyone ever use sub-partitioning?
If your primary key contains all the columns of the partitioning key, you don't need a global index for the primary key - you can use a local index.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
June 2004 UK - Optimising Oracle Seminar July 2004 USA West Coast, Optimising Oracle Seminar August 2004 Charlotte NC, Optimising Oracle Seminar September 2004 USA East Coast, Optimising Oracle Seminar September2004 UK - Optimising Oracle Seminar
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?
![]() |
![]() |