CLEAN-QUERY-STATS
CLEAN-QUERY-STATS
Name
CLEAN QUERY STATS
Description
This statement is used to clear query statistics
grammar:
CLEAN [ALL| DATABASE | TABLE] QUERY STATS [[FOR db_name]|[FROM|IN] table_name]];
Remarks:
- If ALL is specified, all query statistics are cleared, including database and table, admin privilege is needed
- If DATABASE is specified, the query statistics of the specified database are cleared, alter privilege for this database is needed
- If TABLE is specified, the query statistics of the specified table are cleared, alter privilege for this table is needed
Example
Clear all statistics
clean all query stats;
Clear the specified database statistics
clean database query stats for test_query_db;
Clear the specified table statistics
clean table query stats from test_query_db.baseall;
Keywords
CLEAN, QUERY, STATS