Home > Articles > Data > SQL Server

Tuning MDX: Improving Performance with Caches

  • Print
  • + Share This
Join author Bill Pearson in exploring ways to optimize performance in MDX queries. This article focuses on the types of intervention within which you can increase efficiency in MDX execution, as well as surrounding considerations for improving overall query performance.
Like this article? We recommend

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."

  • + Share This
  • 🔖 Save To Your Account