About the Talk
September 16, 2010 5:00 AM
“Like other occult techniques of divination, the statistical method has a private jargon deliberately contrived to obscure its methods from non-practitioners.” Ashley-Perry Statistical Axioms
Statistics are the lifeblood of a cost-based optimizer such as SQL Server’s and are a key component of performance tuning. This session will attempt to demystify statistics in regard to the SQL Server 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.