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 |