Purpose
This statement is used to drop an index. When there are too many indexes, the maintenance overhead increases, so it is necessary to drop unnecessary indexes.
Limitations and considerations
When dropping an index, you need to wait for a period of time before it is completely dropped.
Privilege requirements
To execute the DROP INDEX statement, the current user must have the DROP system privilege. For more information about OceanBase Database privileges, see Privilege classification in Oracle mode.
Syntax
DROP INDEX [schema.] index_name;
Parameters
| Parameter | Description |
|---|---|
| schema | Specifies the schema name. |
| index_name | Specifies the index name. |
Examples
Drop the index tbl1_idx1.
obclient> DROP INDEX tbl1_idx1;
Query OK, 0 rows affected