DELETE STATISTICS

---

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

Usage

Embedded/Interactive/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 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 Mimer SQL System Management Handbook, Database Statistics.

Standard Compliance

Standard	Compliance	Comments
	Mimer SQL extension	The DELETE STATISTICS statement is a Mimer SQL extension.

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se