Analysis Services
Partitions
Partitions are used to store and manage precalculated aggregations and, sometimes, source data. They also offer flexibility in storing such data in multiple locations and in optimizing its access; they are also useful in managing the growth of cubes over time.
The following topics describe structural considerations for partitions.
| Topic | Description |
|---|---|
| Introduction to Partitions | Describes basic characteristics of partitions and provides an example of a multiple-partition cube |
| Partition Structure | Identifies requirements pertaining to the structure of partitions |
| Partition Storage | Describes differences between the three storage modes |
| Indexed Views for ROLAP Partitions | Identifies conditions necessary for Microsoft® SQL Server™ 2000 Analysis Services to create indexed views for aggregations |
| Remote Partitions | Describes remote partitions and their restrictions |
| Incremental Updates and Partitions | Identifies considerations relative to updating partitions incrementally |