Re: Partitioning problems - Oracle 8.1.7.4

Hi Tony,



> Because I have a global PK index I thought

> that letting the table grow would

> have an adverse affect on performance for this index, so archiving a

> partition off would make sense.



Yes, that is true, but on the other side you loose the control of 
uniqueness; a duplicated record could be re-entered after archiving the 
former one.



If you check the unique constraint (i.e. non of the records in the temporary 
table exists in the partitioned table) *before* each exchange partition 
(and you move the duplicated records in an exception table before the 
exchange) you probably don't need the global index at all.



Regards



Jaromir

----- Original Message ----- 
From: <Tony.Adolph@xxxxxx>
To: <jaromir@xxxxxxxxxxxx>
Cc: <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, February 07, 2005 11:14 AM
Subject: Re: Partitioning problems - Oracle 8.1.7.4 


--
http://www.freelists.org/webpage/oracle-l

Other related posts: