Deleting Statistics from a Data Partition

The delete statistics command allows you to drop statistics for data partitions..

  1. In the Administration Console view, select ASE Servers > Schema Objects > Tables > User Tables.
  2. Select the table that contains the columns on which to delete statistics from a particular data partition.
  3. Click Properties.
    You see the Table Properties screen.
  4. Select the Partitions screen.
  5. Select the data partition on which to delete statistics.
  6. Select Delete Statistics.
    SCC starts the Delete Statistics wizard.
  7. On the Summary screen, verify your selections.
  8. Click Finish.