Drop an index

Maintenance overhead increases with the number of indexes. We recommend that you drop unnecessary indexes.

Syntax

Syntax for dropping an index:

ALTER TABLE table_name DROP key|index index_name;

or

DROP INDEX index_name ON table_name;

Example

Example of dropping an index:

obclient> ALTER TABLE t3 DROP KEY t3_uk, DROP KEY t3_ind3;
Query OK, 0 rows affected