Index

Translation reference to convert INDEX statement to Snowflake

Applies to

Example of Create Index

CREATE INDEX my_index_name ON my_table (column1, column2);

Due to architectural reasons, Snowflake does not support indexes so, SnowConvert will remove all the code related to the creation of indexes. Snowflake automatically creates micro-partitions for every table that help speed up the performance of DML operations, the user does not have to worry about creating or managing these micro-partitions.

Usually, this is enough to have a very good query performance however, there are ways to improve it by creating data clustering keys. Snowflake's official page provides more information about micro-partitions and data clustering.

Last updated