Understanding #DAX Query Plans for #powerpivot and #tabular
Posted
by Marco Russo (SQLBI)
on SQL Blog
See other posts from SQL Blog
or by Marco Russo (SQLBI)
Published on Mon, 22 Jul 2013 13:06:00 GMT
Indexed on
2013/08/02
15:54 UTC
Read the original article
Hit count: 294
Alberto Ferrari wrote a very interesting white paper about DAX query plans. We published it on a page where we'll gather articles and tools about DAX query plans: http://www.sqlbi.com/topics/query-plans/
I reviewed the paper and this is the result of many months of study - we know that we just scratched the surface of this topic, also because we still don't have enough information about internal behavior of many of the operators contained in a query plan. However, by reading the paper you will start reading a query plan and you will understand how it works the optimization found by Chris Webb one month ago to the events-in-progress scenario. The white paper also contains a more optimized query (10 time faster), even if the performance depends on data distribution and the best choice really depends on the data you have. Now you should be curious enough to read the paper until the end, because the more optimized query is the last example in the paper!
© SQL Blog or respective owner