Drop an index

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

Syntax for dropping an index:

DROP INDEX index_name;

Example:

obclient> DROP INDEX t3_ind2;
Query OK, 0 rows affected (0.02 sec)