云数据库 GaussDB-CREATE INDEX:语法格式

时间：2023-11-01 16:22:10

云数据库 GaussDB

语法格式

在表上创建索引。

CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [schema_name.]index_name ] ON table_name [ USING method ]    ({ { column_name | ( expression ) } [ COLLATE collation ] [ opclass ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ] }[, ...] )    [ INCLUDE ( column_name [, ...] )]    [ WITH ( {storage_parameter = value} [, ... ] ) ]    [ TABLESPACE tablespace_name ]    [ WHERE predicate ];

在分区表上创建索引。

CREATE [ UNIQUE ] INDEX [ [schema_name.]index_name ] ON table_name [ USING method ]    ( {{ column_name | ( expression ) } [ COLLATE collation ] [ opclass ] [ ASC | DESC ] [ NULLS LAST ] }[, ...] )    [ LOCAL [ ( { PARTITION index_partition_name | SUBPARTITION index_subpartition_name [ TABLESPACE index_partition_tablespace ] } [, ...] ) ] | GLOBAL ]    [ INCLUDE ( column_name [, ...] )]    [ WITH ( { storage_parameter = value } [, ...] ) ]    [ TABLESPACE tablespace_name ]    [ WHERE predicate ];

上一篇：云数据库 GaussDB-CREATE INDEX:注意事项

下一篇：云数据库 GaussDB-CREATE INDEX:功能描述