Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tag Optimiser Rss

   Items 1 to 1 of 1   

SQL Server Optimizer – Under the Hood Part 1

In this series of short articles, we lift the hood of the SQL Server Optimizer to examine a few of the many clever tricks used to optimize query performance. In Part I, we look at partial aggregate operators – an extremely clever way of downsizing certain large joins into much smaller (and faster) joins.  Read more...
By Additional Articles 2014/01/01 | Source: SQL Server Performance | Category: optimiser
Rating: (not yet rated)  Rate this |   Briefcase | 3,284 reads
   Items 1 to 1 of 1