Description
The DROP INDEX statement deletes an index. Maintenance overheads increase if excessive indexes exist. Therefore, unnecessary indexes need to be deleted.
When you delete an index, you need to wait for a period before the index is completely deleted.
Syntax
DROP INDEX [schema.]indexname;
Parameter description
| Parameter | Description |
|---|---|
| schema | Specifies the schema name. |
| indexname | Specifies the index name. |
Examples
- Delete the index test_index.
DROP INDEX test_index;