Deleting Partition Statistics

Delete table statistics from partitions.

  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 on the partition.
  4. Select Properties.
  5. Click Partitions.
  6. Select the partition from which to delete statistics.
  7. Select Delete Statistics.
  8. Click Finish to delete statistics on the selected partition.
Related tasks
Updating Partition Statistics
Using a Hash Partition
Using a Range Partition
Using a List Partition
Using a Round-Robin Partition
Enabling Semantic-based Partitioning