DAX Query Plans - SQLBI

DAX Query Plans Introduction to performance analysis and DAX optimizations using Query Plans Author: Alberto Ferrari Published: Version Revision 2 July 17, 2012 Contact: Summary: This paper is an introduction to Query optimization of DAX code through the usage of the DAX Query Plans . It uses the Contoso database, which you can download from here: and the Tabular version of AdventureWorks, available on CodePlex. Acknowledgments: I would like to thank the peer reviewers that helped me improving this document: Marco Russo, Chris Webb, Greg Galloway, Ashvini Sharma, Owen Graupman and all our ssas-insiders friends.

DAX Query Plan: this event is fired when the query engine has finished computing the query plan and contains a textual representation of the query plan. As you will learn, there are two different query plans, so you will always see two instances of this event for any DAX query. MDX queries, on

Tags:

  Plan, Query, Dax query plans

Information