Transcription of DAX Query Plans - SQLBI
{{id}} {{{paragraph}}}
Example: marketing
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. I would also like to give a special thanks to Anand, Marius Dumitru, Cristian Petculescu, Jeffrey Wang, Ashvini Sharma, and Akshai Mirchandani who constantly answer to all of our fancy questions about SSAS.
Scan, is the query as the SSAS engine originally requested it; event subclass 10, i.e. VertiPaq Scan Internal, is the same query, rewritten by the VertiPaq engine for optimization. The two query are – in reality – a single VertiPaq operation for which two different events are logged. The two queries are always identical, apart
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: