Deleting Statistics from a Table

Use SAP Control Center to drop statistics for tables.

  1. In the Administration Console view, select ASE Servers > Schema Objects > Tables > User Tables.
  2. Click the Name field of the table, then click the drop-down arrow and select Delete Statistics.
  3. (Optional) 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.
  4. On the columns screen, click the columns from which to delete statistics.
  5. Verify your selections on the Summary screen.
  6. Click Finish.