Deleting Statistics from a Column

Use SAP Control Center to drop statistics for specific columns.

  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 Properties.
  3. In the left pane, click Columns.
  4. Click the Name field of the column, then click the drop-down arrow and select Delete Statistics.
  5. 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.
  6. Verify your selections on the Summary screen.
  7. Click Finish.