Selecting Tables for Partitioning
If you’ve ever asked yourself any of the following questions:
“How do I determine if table partitioning will help improve my deployment’s maintenance and performance capabilities? ”
“I’ve got 8,000 tables in my database. Which ones are the best candidates for partitioning?”
“How do I choose the columns and partition types to use when adopting table partitioning?”
Then you’ll certainly want to read this white paper.