Manage Statistics Dialog Box

SQL Query Analyzer Help

SQL Query Analyzer Help

Manage Statistics Dialog Box

Use the Manage Statistics dialog box to select the database and table or view for which you want to create, edit, or delete statistics.

Options

Database

Specify the database.

Table/view

Specify the table or view for which to create, edit, or delete statistics.

Include system objects

Specify to include system objects in the list of tables and views.

Name

Lists the names of existing statistics.

Columns

Shows the columns on which existing statistics are based.

New

Open the Create Statistics dialog box to define a new statistic.

Update

Update the selected statistic in the Update Statistics dialog box.

Delete

Delete the selected statistic.