DELETE STATISTICS

Deletes the statistics recorded for all tables in the database, a specified list of tables, all tables in a specified list of schemas or all the tables belonging to the schemas owned by a specified list of idents.

 

Usage

Embedded, Interactive, Module, ODBC, JDBC.

Description

The default operation is to delete statistics for all tables, including data dictionary tables, in the database.

It is possible to delete statistics for a specified list of tables by using the FOR TABLE option, for all tables belonging to a specified list of schemas by using the FOR SCHEMA option or for all the tables belonging to the schemas created by a specified list of idents by using the FOR IDENT option.

Restrictions

The current ident must be the creator of all the tables involved or must have STATISTICS privilege.

Notes

The DELETE STATISTICS statement can be used concurrently with other SQL statements.

Example

DELETE STATISTICS FOR IDENT joe;

 

For more information, see the System Management Manual, Database Statistics.

Standard Compliance