All Products
Search
Document Center

DROP INDEX

Last Updated: Jun 18, 2021

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;