O'Reilly logo

MDX with Microsoft SQL Server 2008 R2 Analysis Services: Cookbook by Tomislav Piasevoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Query optimization

The Query optimization section is dedicated to explaining concepts relevant to the process of optimizing queries: block computation, cell-by-cell mode, arbitrary shaped sets, varying attributes, sparse and dense calculations, types of cache, and so on.

Block-computation versus cell-by-cell evaluation mode

Block-computation mode, also known as subspace mode, is a process of evaluating cells in blocks. It is a mode that is many times faster than the cell-by-cell mode. Most MDX functions (http://tinyurl.com/Improved2008R2) are optimized to work in that mode. However, by applying non-optimized calculations we can prevent that, accidentally or on purpose.

Related recipes:

  • Iterating on a set in order to reduce it (chapter 1)
  • Calculating ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required