SSC-FDM-0021

Create Index Not Supported

Description

Due to architectural reasons, Snowflake does not support indexes so, SnowConvert will comment out 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.

Example Code

Input Code (Oracle):

IN -> Oracle_01.sql

CREATE INDEX index1
ON table1(column1);

Output Code:

OUT -> Oracle_01.sql

----** SSC-FDM-0021 - CREATE INDEX IS NOT SUPPORTED BY SNOWFLAKE **
----** SSC-FDM-0007 - MISSING DEPENDENT OBJECT "table1" **
--CREATE INDEX index1
--ON table1(column1)
                  ;

Recommendations

• Data clustering might be a way to speed up query performance on tables.

• If you need more support, you can email us at [e-mail]