Dropping statistics permanently removes statistical data that has already been collected for specified columns and indexes of a table.
- In the Object List Viewer, select the tables for which you wish to drop statistics.
-
Right-click a table and do one of the following:
To drop Complete the following: Table statistics - Select .
- Click OK to confirm the drop operation.
Column statistics - Select .
- Click Commit.