Re: Am I doing this correctly?
Posted by:
Rick James
Date: November 30, 2013 02:18PM
> Why did I have to add my field 'CreationDate' to the unique key?
Otherwise, it would have to check _all_ partitions whenever you insert a row. (This is to check the UNIQUEness.)
While your PARTITION+SUBPARTITION syntax may be correct, I see no use for it. What do you hope to achieve?...
Performance on INSERT? INSERTs are slowed down by PARTITIONing, especially with so many partitions?
Performance on SELECT? Let's see your SELECT(s). I suspect they will not benefit.
Purging old data? If you will do DROP PARTITION, then this is a big benefit.
Subject
Views
Written By
Posted
2769
November 29, 2013 05:03AM
1585
November 29, 2013 06:22AM
Re: Am I doing this correctly?
1682
November 30, 2013 02:18PM
1463
December 04, 2013 12:38AM
1533
December 05, 2013 03:48AM
1590
December 05, 2013 10:21AM
1502
December 10, 2013 09:49AM
1529
December 05, 2013 03:51AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.