Create Missing Statistics Dialog Box
Use the Create Missing Statistics dialog box to create missing statistics. SQL Query Analyzer suggests additional indexes and statistics on nonindexed columns that would improve the query optimizer's ability to process a query. In particular, SQL Query Analyzer displays missing statistics so that they can be created.
View the name of the statistic missing from the selected column.
View the column missing the specified statistics.
View the type of column missing the specified statistics.
Amount of data to sample
Specify how much data to sample for the statistic.
|Default||Select to sample the default amount of data for the selected statistic.|
|Sample all the data||Specify to sample all of the data for the selected statistic.|
|Sample % of the data||Specify the percentage of the data to sample for the selected statistic.|
Do not automatically recompute statistics
Specify to not automatically recompute statistics. This is not recommended.
Open the Edit Transact-SQL Script dialog box to edit the CREATE STATISTICS statement.