Jul 4 2008, 08:46 AM
I have a table which is having 50 million records and having compound primary key.
I am planing to partition the table,
not sure which would improves the performance index partitioning or table partitioning or both.
Thanks and regards
Jul 4 2008, 09:24 AM
Huge subject, too much to post in this forum for a general question like yours. Read up on partitioning and then come back with a specific question or questions.
What is your primary key based on? Keep that in mind when reading about suitable partition keys, especially since you say that your current key is compound.
Partitioning can help with performance, and it can help with administration/maintenance of a table.