Delete an index

Maintenance costs increase with the number of indexes. We recommend that you delete unnecessary indexes.

MySQL mode

In MySQL mode, you can use either of the following statements to delete an index:

ALTER TABLE table_name DROP key|index index_name ;

or

DROP INDEX index_name ON table_name;

Example:

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

Oracle mode

In Oracle mode, you can use the following statement to delete an index:

DROP INDEX index_name ;

Example:

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