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.