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 the following white paper available here