DROP INDEX

Description

This statement is used to drop an index. When there are too many indexes, the maintenance cost increases. Therefore, unnecessary indexes need to be dropped.

Syntax

DROP INDEX index_name
   ON table_name;

Parameters

Parameter	Description
index_name	The name of the index.
table_name	The name of the table.

Examples

Drop the idx_test index from the tbl_test table.

DROP INDEX idx_test ON tbl_test;