- About the Series
- Introduction to Performance Tuning
- Understanding How Queries Are Processed
- Types of Intervention
- Large Level Threshold Property
- Location of Query Processing
- Optimization of Set Operations
- Importance of Optimal Arrangement
- Expression Arrangement
- Caching and Optimization
- Other Performance Enhancement Options
- A Parting Word
Optimization of Set Operations
We have seen that options exist in the form of the Execution Location and Large Level Threshold properties to influence the physical location in which a query is processed. This intervention type itself could allow us to take advantage of performance gains based upon our being able to assign resources appropriately. While the Analysis Server provides for tuning in its provision for the establishment of a large level threshold, optimal syntax arrangement in our queries is perhaps a more important consideration. And before we can bring about optimal performance in this area, we need to gain a solid understanding of how the PivotTable Service works.