Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

Create Missing Statistics Dialog Box

SQL Server 2000

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.