About the Talk
August 12, 2010 2:30 PM
Winston Salem NCWinston Salem NC
Statistics are the life blood of a cost based optimizers such as SQL Server and are a key component of performance tuning. This session will attempt to demystify statistics in regards to SQL Server the query optimizer. The internals of statistics will be examined and explained so that you will understand what statistics are available, how the optimizer uses those statistics, what causes statistics to be recomputed and when it happens.