Topic: Query Plans

Every DAX query generates query plans describing operations performed by the xVelocity (VertiPaq) engine. This page contains documents and resources enabling you to read these query plans and use such information to optimize your DAX queries.

5 results
  • DIVIDE Performance

    The DIVIDE function in DAX is usually faster to avoid division-by-zero errors than the simple division operator. However, there are exceptions to this rule, described in this article through a simple performance analysis.  Read more

  • Analysis Services Tabular can be used in large-scale solutions and SQLBI already helped several companies in the challenging effort of defining a reliable and scalable architecture, designing the right data model and optimizing the queries. One of these stories is…  Read more

  • 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.  Read more