All Products
Search
Document Center

DROP INDEX

Last Updated: Jun 18, 2021

Description

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.

Syntax

DROP INDEX indexname 
   ON tblname;

Parameters

Parameter

Description

indexname

The name of the index.

tblname

The name of the table.

Examples

  • Delete index test_index.
DROP INDEX test_index ON test;