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 | 2,851 reads
   Items 1 to 1 of 1