Deleting Table Statistics

The Delete Statistics wizard allows you to remove statistics for 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 the table for which to update statistics.
  4. Select Delete Statistics.
  5. Click Finish to delete statistics on the selected table.
Parent topic: Managing Table Statistics