DROP INDEX
Purpose
You can use this statement to drop an index. Maintenance costs increase with the number of indexes. We recommend that you drop unnecessary indexes.
Syntax
DROP INDEX index_name
ON table_name;
Parameters
| Parameter | Description |
|---|---|
| index_name | The name of the index. |
| table_name | The table name. |
Examples
Drop the idx_test index for table tbl_test.
obclient>DROP INDEX idx_test ON tbl_test;