The Details page of the Statistics Properties dialog box shows the information collected in the currently selected statistic object. This information is used by the query optimizer to create the best possible query plan.
Statistics can be collected by examining every row in the table or by sampling a large table. When sampling was used, or when statistics are out of date, the statistics presented in the page may not reflect the exact state of the table. The statistics displayed are read-only.
Displays the name of the table described by the statistics.
Displays the name of the database object where the statistics are stored. Statistics unrelated to an index which were created automatically by Microsoft SQL Server have names beginning with _WA_Sys.
Displays the name of the statistics object.
Displays the date the current statistics were created.
Displays the number of rows in the table.
Displays the number of rows examined to create the statistics.
The rows of the table are split into groups for the statistics histogram. This is the number of groups that were created.
An index that has a large number of duplicates has high density.
A unique index has low density.
Average Key Length
Displays the average length of each row.
Yes indicates that the statistics contain a string summary index to support estimation of result set sizes for LIKE conditions. (Applies only to leading columns of char, varchar, nchar, and nvarchar data types.)