Delete Statistics

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

Lets you create and issue a DELETE STATISTICS statement, allowing you to delete statistics for a table or for specified columns of a table.

Platform Availability

To Delete Statistics for a Table

  1. Initiate a Delete Statistics action against one or more tables. For more information see Initiating an object operation.
  2. Use the following table as a guide to understanding and modifying settings in the Delete Statistics wizard:
Step Settings and tasks

Action options

Displays the names of the tables you selected and if appropriate, lets you select a specific Partition Name.

Columns (Sybase ASE 15 only)

All columns - lets you delete statistics for all columns in the table. Specific columns - select this option and then select check boxes associated with each specific column for which statistics are to be deleted.


Review the referring and referred objects that will be automatically resolved when you execute this operation. For more information, see Dependencies.


Preview the DDL generated for the operationn. For more information, see Preview.

3. Click Execute. For information on the scheduling option, see Scheduling.