Deleting Column Statistics

The Delete Statistics wizard allows you to remove statistics from an individual column of a table.

Delete statistics applies only to user and proxy tables.

  1. In the Perspective Resources view, select the server on which the table resides, then click the drop-down arrow next to the server name and select Administration Console.
  2. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Tables, then choose one of the following:
    • User Tables
    • Proxy Tables
  3. Select a table that contains the column.
  4. Select Properties.
  5. Click Columns.
  6. Select the column for which to update statistics.
  7. Select Delete Statistics.
  8. Click Finish to delete statistics on the selected table.
Parent topic: Managing Table Statistics