|
|
|
|
|
|
|
|
|
Statistics & Using DBCC Show_Statistics
Want to see what SQL has stored for statistics and understand what it all means - view on!
|
|
|
|
Duration:
|
1
mins
36
secs
|
|
Skill Level:
|
100
|
|
Rating:
|
3.82
out of 5
|
|
Publish Date:
|
December 04, 2009
|
|
|
|
About the Author
|
|
Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.
|
|
References
|
There are no downloads or recommended reading links for this video
|
|
|
Comments
|
|
good
|
|
|
Good video on basics of statistics, thanks.
|
|
|
Please elaborate on what density signifies - thx
|
|
|
These stats videos are too fragmented. Great content, well explained, but would much rather have fewer, longer videos.
|
|
Steve Harris on
12/22/2009
too short ... what do I do with this information
|
|
|
James,
Just so you know
Density is a calculated value and it is defined as 1 / distinct values for ALL key columns. That is why the value changed when Andy added more columns to an index....
|
|
|
too short but useful..
|
|
|
Did not explain some terms (e.g. density).
It was good to know we don't need to think much about Avg. Length info.
Thanks.
|
Must Be Logged In
|
|
|
|
|