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

Drops a join index.

Syntax

DROP JOIN INDEX [schema_name.]join_index_name;

Description

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

See Also

CREATE JOIN INDEX

  • No labels