Deleting Statistics from a Column

The delete statistics command allows you to drop statistics for specific columns.

1. In the Administration Console view, select ASE Servers > Schema Objects > Tables > User Tables.
2. Select the table from which to delete statistics.
3. Click Properties.
   SCC displays the Table Properties screen.
4. Select the Columns screen.
5. Select the column on which to delete statistics.
6. Select Delete Statistics.
7. 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.
8. Click Next.
9. Verify your selections on the Summary screen.
10. Click Finish.