Designing Partitions
Just as with indexes, partitions should be designed carefully in order to be effective. As with indexes, in order to take advantage of data partitioning, you must provide the partitioning column in the WHERE clause of your SQL statements for the partitioning scheme to be evaluated and utilized. Consider the following criteria to design partitions effectively:
How will this data be used? Are there criteria that are regularly used in the WHERE clause of your SQL statement?
How is data aggregated? Do reports look at data for each month, quarter, or year?
Is data separated by account? Do accounts mix, or do you always look at one account at a time?
Are there common SELECT criteria? Is there some data that is always used in the WHERE ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
