Home > Articles > Data > SQL Server

  • Print
  • + Share This
Like this article? We recommend

A Parting Word

In this article, we discussed how Analysis Services handles queries as a preparation for our focus on optimization techniques. We next discussed several types of intervention that we can use for query optimization. We explored the Large Level Threshold property, and touched upon its rather ubiquitous influence and its role in our next area of examination: the location of query execution. We then focused on the importance of the optimization of set operations and explored a couple of examples that illustrated numerous ways we can rearrange queries to enhance performance, often significantly. We then exposed two methods of caching to load a commonly used slice of a cube into memory, making for faster retrieval in prospective operations. We discussed the creation scope for caches, within the context of both the CREATE CACHE statement and the WITH statement, and discussed appropriate uses for each. Finally, we touched upon other performance-enhancement options, including external functions and cube design modifications and augmentation.

  • + Share This
  • 🔖 Save To Your Account