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.
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 TABLEoption, for all tables belonging to a specified list of schemas by using the
FOR SCHEMAoption or for all the tables belonging to the schemas created by a specified list of idents by using the
The current ident must be the creator of all the tables involved or must have
DELETE STATISTICSstatement 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