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
2809
November 29, 2013 05:03AM
1607
November 29, 2013 06:22AM
Re: Am I doing this correctly?
1707
November 30, 2013 02:18PM
1489
December 04, 2013 12:38AM
1555
December 05, 2013 03:48AM
1615
December 05, 2013 10:21AM
1522
December 10, 2013 09:49AM
1559
December 05, 2013 03:51AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.