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.