DROP { STATISTICS | STATS | STAT } [ statistic ][,...] ON indexed_item [;]
- statistic
{ [UNIQUE] INDEX [ index_name ] [ALL] ( column_name_1 [,...] ) [ ORDER BY [ VALUES | HASH ] ( column_name_2 ) ] | COLUMN { column_index | ( column_index [,...] ) } }
- indexed_item
{ [TEMPORARY] [ database_name. | user_name. ] table_name | [ database_name. | user_name. ] { join_index_name | hash_index_name } }
- column_index
{ column_name [ [AS] statistics_name ] | PARTITION }