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.
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.
The current ident must be the creator of all the tables involved or must have STATISTICS privilege.
The DELETE STATISTICS statement can be used concurrently with other SQL statements.
ExampleDELETE STATISTICS FOR IDENT joe;
For more information, see the Mimer SQL System Management Handbook, Database Statistics.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40