UPDATE STATISTICS PRIMER

[NWChowd]

I am trying to gain more in-depth knowledge of SQL Server distribution statistics and how to effectively use this information, and how often to update statistics. In general, this is a nebulous topic for me, and I am looking for a clear description.

Does anyone have any pointers or resources that might clear this up for me??

Thanks,
NWChowd

======================================
"I wish that I may never think the smiles of the great and powerful a sufficient inducement to turn aside from the straight path of honesty and the convictions of my own mind."
-David Ricardo, classical economist
======================================

 

[vongrunt]

For starters, BOL (Books Online) as usual. Check the following topics (Index tab):

- statistical information -> distribution statistics
- sp_autostats
- sp_dboption
- CREATE|UPDATE STATISTICS
- DBCC SHOW_STATISTICS
etc.

Then visit

http://www.sql-server-performance.com/nb_execution_plan_statistics.asp

------
Math problems? Call 0800-[(10x)(13i)^2]-[sin(xy)/2.362x]

 

[NWChowd]

Great information, VonGrunt. thanks!

======================================
"I wish that I may never think the smiles of the great and powerful a sufficient inducement to turn aside from the straight path of honesty and the convictions of my own mind."
-David Ricardo, classical economist
======================================