Page tree
Skip to end of metadata
Go to start of metadata

Drops a range index

Syntax

DROP RANGE INDEX [schema_name.]range_index_name;

Description

Internally, the command only marks the range index for deletion. The dropped range index is physically deleted later by the background maintenance service. New queries will not see the dropped range index, but in-flight queries will finish executing successfully, as if they started execution right before the range index was dropped.

See Also

CREATE RANGE INDEX

  • No labels