You can execute the DROP INDEX statement to delete an index. A large number of indexes require high maintenance overheads. We recommend that you delete the indexes that are not required.
After you execute the DROP INDEX statement to delete an index, the index cannot be immediately deleted. Wait for a period before the index is deleted.
DROP INDEX indexname ON tblname;
The name of the index.
The name of the table.
- Delete index test_index.
DROP INDEX test_index ON test;