12/17/2012
What is a partition in SSAS
A partition in Analysis Services is the physical location of stored cube data.
Every cube has at least one partition by default. Each time we create a measure
group, another partition is created. Queries run faster against a partitioned
cube because Analysis Services only needs to read data from the partitions that
contain the answers to the queries. Queries run even faster when partition also
stores aggregations, the pre calculated totals for additive measures.
Partitions are a powerful and flexible means of managing cubes, especially
large cubes.
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment