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)
;
Related EWIs
MSCINF0011: Create Index is not supported.
Last updated
Was this helpful?