DROP RANGE INDEX

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