The Delete Statistics wizard allows you to remove statistics from an individual column of a table.
Delete statistics applies only to user and proxy tables.
- In the Perspective Resources view, select the server on which the table resides, then click the drop-down arrow next to the server name and select Administration Console.
- In the left pane of the Administration Console, expand , then choose one of the following:
- Select a table that contains the column.
- Select Properties.
- Click Columns.
- Select the column for which to update statistics.
- Select Delete Statistics.
- Click Finish to delete statistics on the selected table.