Home > Articles > Data > SQL Server

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

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.

  • + Share This
  • 🔖 Save To Your Account