Create Statistics Dialog Box

Create Statistics Dialog Box

SQL Server 2000

Use the Create Statistics dialog box to define statistics on the database and table specified in the Manage Statistics dialog box.



Specify the name of the statistic to create.


Specify the columns to include in the new statistic.

Data type

View the data type of the column.

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 statistic.
Sample % of the data Specify the percentage of the data to sample for the statistic.
Sample all the data Specify to sample all of the data for the 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.

© 2016 Microsoft