Main Content

Statistics, how to prove everything but the truth

About the Talk

September 16, 2010 5:00 AM

http://www.sqlpass.org/24hours/fall2010/default.aspx

http://www.sqlpass.org/24hours/fall2010/default.aspx

“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.

Ratings and Recommendations

Avg. Rating

Average based
on 4 ratings

comments powered by Disqus