Tuning MDX: Improving Performance with Caches
- 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
About the Series
This is the last tutorial article of our series, "Introduction to MDX." As we discussed in the first article, "Basic Concepts and Navigation," the primary focus of this series is the creation of basic MDX expressions and queries for use with multidimensional data sources. The lessons in the series continually add more features to our progressively growing familiarity with MDX, allowing us to use the MDX language in a variety of scenarios designed to meet specific real-world needs.
The articles of the series are intended to serve as stand-alone lessons: Although each builds upon the concepts of the articles that preceded it, except where noted, each article is based upon objects and steps created within it that are independent of the steps taken in earlier articles. For more information on the series, as well as the hardware/software requirements to prepare for the tutorials we will undertake throughout, please see my initial article, "Basic Concepts and Navigation."