Understanding DAX Query Plans

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

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.


Tags: dax, paper, must read


2007-2015 VidasSoft Systems Inc.