ALTER MATERIALIZED VIEW ALTER COLUMN DROP INDEX

Removes an existing index from a column of type symbol.

Syntax​

Flow chart showing the syntax of the ALTER MATERIALIZED VIEW keyword Flow chart showing the syntax of the ALTER MATERIELIZED with DROP INDEX keyword

Removing an index is an atomic, non-blocking, and non-waiting operation. Once the operation is completed, the SQL engine stops using the index for SQL executions, and all its associated files are deleted.

Example​

Removing an index from a materialized view
ALTER MATERIALIZED VIEW trades
    ALTER COLUMN instrument DROP INDEX;