CREATE INDEX

Description

Constructs an index on the specified column(s) of the specified table or materialized view.

Click here to navigate to the Greenplum documentation page for this syntax.

Create Index is not supported in Snowflake

Grammar Syntax

CREATE [UNIQUE] INDEX [name] ON table_name [USING method]
       ( {column_name | (expression)} [COLLATE parameter] [opclass] [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [, ...] )
       [ WITH ( storage_parameter = value [, ... ] ) ]
       [ TABLESPACE tablespace ]
       [ WHERE predicate ]

Sample Source Patterns

Greenplum

CREATE UNIQUE INDEX title_idx ON films (title);

Snowflake

-- ** MSC-INFORMATION - MSCINF0011 - CREATE INDEX NOT SUPPORTED. **
--CREATE UNIQUE INDEX title_idx ON films (title)
                                              ;

Last updated