Primary keys and partitioned tables
If you are planning to partition a table, assure that it has no primary keys. If you need some way of ensuring that no duplicate records are inserted, use a unique index instead.
Why? Because exchanging a table partition with a table will validate the primary key regardless of 'INCLUDING INDEXES WITHOUT VALIDATION' clause. To validate the primary key a full index scan will be performed. That isn't a problem if the table is small, but then who in his right mind will be partitioning a small table?
posted by Pedro Oliveira @ 5:39 AM
0 Comments:
Post a Comment
<< Home