Delete Statistics
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
- Initiate a Delete Statistics action against one or more tables. For more information see Initiating an object operation.
- 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. | |
Dependencies |
Review the referring and referred objects that will be automatically resolved when you execute this operation. For more information, see Dependencies. | |
Preview |
Preview the DDL generated for the operationn. For more information, see Preview. |
- 3. Click Execute. For information on the scheduling option, see Scheduling.