- About the Series
- Introduction to Performance Tuning
- Understanding How Queries Are Processed
- Types of Intervention
- Large Level Threshold Property
- Location of Query Processing
- Optimization of Set Operations
- Importance of Optimal Arrangement
- Expression Arrangement
- Caching and Optimization
- Other Performance Enhancement Options
- A Parting Word
Like this article? We recommend
Like this article? We recommend
Like this article? We recommend
A Parting Word
In this article, we discussed how Analysis Services handles queries as a preparation for our focus on optimization techniques. We next discussed several types of intervention that we can use for query optimization. We explored the Large Level Threshold property, and touched upon its rather ubiquitous influence and its role in our next area of examination: the location of query execution. We then focused on the importance of the optimization of set operations and explored a couple of examples that illustrated numerous ways we can rearrange queries to enhance performance, often significantly. We then exposed two methods of caching to load a commonly used slice of a cube into memory, making for faster retrieval in prospective operations. We discussed the creation scope for caches, within the context of both the CREATE CACHE statement and the WITH statement, and discussed appropriate uses for each. Finally, we touched upon other performance-enhancement options, including external functions and cube design modifications and augmentation.