I have a table with more than 30 million records .now i thought of partitioning the table on primary key please suggest me the approach.
I usually ask myself a series of questions when the idea of partitioning a table pops-up on my mind, here are the basic ones:
1- Any particular reason to partition this table?
2- How many partitions?
3- What would be the partitioning key?
4- Would partitioning strategy help during archiving and purging of this table?
5- Would partitioning strategy improve performance? How and why?
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at Amazon and other bookstores.Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.