Deleting Statistics from a Table

The delete statistics command allows you to drop statistics for tables.

1. In the Administration Console view, select ASE Servers > Schema Objects > Tables > User Tables.
2. Select the table from which to delete statistics.
3. Select Delete Statistics.
   SCC starts the Delete Statistics wizard.
4. On the Data Partitions screen, select Specify a data partition, if applicable, and indicate any data partitions. update statistics runs on all partitions if you do not specify one. Click Next.
5. Click Next.
6. Select the Columns screen and click on the column on which to delete statistics.
7. Click Next.
8. Verify your selections on the Summary screen.
9. Click Finish.