Understanding DAX Query Plans
User Rating: / 1
PoorBest 
Written by Alberto Ferrari   
Wednesday, 17 July 2013 18:29

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.

Read more...

 

 

Pyramid Analytics