Modify primary key for partitioning
Hi,
I want to use range partitioning for a table. Currently, this table has a primary key based on one column (not an auto-increment, but a unique varchar). In order to create the partitioning, I must add the column (datetime) I want to partition on, to the primary key. Therefore, the primary key will be less restrictive (I can have twice the same varchar if the datetime is different). A solution is to enforce a unique key on the varchar column, so that I can't get twice the same value. I'm just wondering if it's a good idea to have a column once in the primary key plus an unique index on it (mainly for the performance). What do you think of this design ? Do you have any better suggestion ?
Regards,
Edited 1 time(s). Last edit at 08/11/2012 04:22AM by Aurelien PANIZZA.
Subject
Views
Written By
Posted
Modify primary key for partitioning
3192
August 10, 2012 10:29AM
1802
August 18, 2012 09:39PM
2077
August 20, 2012 06:33AM
1822
August 22, 2012 10:16AM
1919
August 23, 2012 09:16AM
1807
August 23, 2012 10:42AM
1802
August 28, 2012 10:14AM
1809
August 30, 2012 10:26PM
2254
August 31, 2012 03:05AM
1831
August 31, 2012 03:38AM
1744
August 31, 2012 06:48AM
1834
August 31, 2012 09:39AM
1717
September 04, 2012 01:02AM
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.