Articles   \  

Understanding DAX Query Plans



queryplans

Understanding DAX query plans is a long process. This paper explains how to capture and read a DAX query plan, helping you to find possible optimizations of your DAX queries.

The paper is divided in three sections:

  • Looking at your first query explains what are the events to observe in the Profiler and guide you Step-by-Step in reading them for a simple query
  • Formula Engine and Storage Engine shows the different roles of the two engines and how to identify which operations are performed by each engine
  • Events in Progress analyzes a non-trivial query and illustrates the differences in query plans of more optimized DAX versions of the same query

The goal of the paper is to introduce the reading of a query plan. A more detailed analysis of each operation in the query plan will be the topic of a future paper.

Download Paper (PDF)







 
Want to read more?