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.
Options
Statistics name
View the name of the statistic missing from the selected column.
Column name
View the column missing the specified statistics.
Column type
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.
Edit SQL
Open the Edit Transact-SQL Script dialog box to edit the CREATE STATISTICS statement.