Database Reference
In-Depth Information
7
how aso works
and
how to desIgn For PerFormanCe
Dan Pressman
Contents
7.1 Introduction
226
7.1.1
Who Should read This Chapter
226
7.1.2
What Will and Will not Be Covered
227
7.2
Summary: rules of ASo Designing for Performance
227
7.3
ASo Queries: how They Work
228
7.3.1
What Does a Cube Look Like?
228
7.3.2
The Essbase ASo Implementation of the Sorting-needle, the holes,
and the notches
230
7.3.3
The Essbase ASo Implementation of the Card Box: The Importance
of memory Space
232
7.3.4
The Essbase Implementation of the Data Card
233
7.3.5
Is It really That Simple?
236
7.4
The Bitmap: Its role and Function
237
7.4.1
Why Should Anyone Care about the Bitmap?
237
7.4.2
how Is the Bitmap Constructed?
237
7.4.3
Primary Lessons from the Bitmap
240
7.5
understanding Aggregations and Slices
253
7.5.1
Aggregation and the Bitmap
254
7.5.2
What Is the meaning of Those numbers in the recommended view?
255
7.5.3
Aggregate view: What Is “Query Cost”
258
7.5.4
So What Is Aggregated and how Is It used?
259
7.5.5
Design Aggregation CSC File
260
7.6
Design Alternatives and Their Costs
262
7.6.1
other types of Cost
262
7.6.2
Alternative Design options: Designing to maximize use of Stored
hierarchies
263
7.7
tips to Improve Data Loading and Aggregation Performance
271
225
 
 
Search WWH ::




Custom Search