DROP JOIN INDEX
- Boaz Raufman
Owned by Boaz Raufman
Feb 26, 2019
1 min read
Loading data...
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.