Partitioning Scenarios
As discussed earlier in this chapter, there are a number of good reasons for using partitioning. This section presents a few scenarios of where and how partitioning can be especially beneficial.
Scenario 1: Partitioning Historical Data
In the first scenario, we will look at how partitioning can benefit systems by partitioning based on historical data. This is probably the most beneficial type of partitioning because most financial systems include data that has a date attached to it. As mentioned earlier in this chapter, I generally do not recommend indexing on date fields.
Probably the most effective method of partitioning a financial database is on date. Not all tables include date fields, but the largest tables (for example, ...
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.
