Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


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
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX