Architecture of Query Execution—Retrieving Data from Storage - Microsoft SQL Server 2008 Analysis Services - page 553

Segment 1
Job

Read Data

Query
Partition 1 Job

Decode Data

Filter Data

Query
Partition 2 Job

Segment 2
Job

…

Query
Measure Group
Job

Read Data

Query
Partition N Job Decode Data

Filter Data

…

Segment N
Job

Read Data

Decode Data

Filter Data

Aggregate
Data

FIGURE 30.2

The scheme Analysis Services uses to query partitions of a regular measure

group.

. Analysis Services validates whether partition contains requested data. It uses

minimum and maximum values of DataID s that were created during index building.
If the DataID s requested in a subcube don't fit into this range, Analysis Services
completes the Query Partition job and doesn't scan the current partition for data.

. Analysis Services optimizes the subcube to include only slices for data in the parti-

tion. This optimization is typically done for requests that contain a set of slices (this