- Explore
- Collaborate
- Visualize
- Connect
- Pricing
How to Drop an Index in Snowflake
As previously mentioned, Snowflake doesn't support the concept of indices.
As a substitute in particular situations, you can use clustering keys. Creation of clustering keys is explained here, and this article will show you how to drop a clustering key for a particular table.
To drop a clustering key, use the ALTER TABLE .. DROP CLUSTERING KEY
command:
-- syntax
alter table table_name drop clustering key;
alter table active_users drop clustering key;
From Snowflake query to chart to Slack in seconds
Get to answers faster, together, with PopSQL and Snowflake
Previous
From Snowflake query to chart to Slack in seconds
Get to answers faster, together, with PopSQL and Snowflake