ALTER MATERIALIZED VIEW DROP INDEX

Removes an existing index from a SYMBOL column in a materialized view.

Syntax

ALTER MATERIALIZED VIEW viewName ALTER COLUMN columnName DROP INDEX

Parameter	Description
`viewName`	Name of the materialized view
`columnName`	Name of the indexed `SYMBOL` column

Remove an index when:

questdb-sql

ALTER MATERIALIZED VIEW trades_hourly
  ALTER COLUMN symbol DROP INDEX;

Aspect	Description
Operation type	Atomic, non-blocking, non-waiting
Immediate effect	SQL optimizer stops using the index
Cleanup	Associated index files are deleted

Dropping an index requires the ALTER MATERIALIZED VIEW permission:

questdb-sql

GRANT ALTER MATERIALIZED VIEW ON trades_hourly TO user1;

Error	Cause
`materialized view does not exist`	View with specified name doesn't exist
`column does not exist`	Column not found in the view
`index does not exist`	Column is not indexed
`permission denied`	Missing `ALTER MATERIALIZED VIEW` permission (Enterprise)