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

时间:2024-11-02 18:46:42

语法格式

CREATE GLOBAL [ UNIQUE ] INDEX [ [schema_name.]index_name ] ON table_name [ USING method ]
    ({ column_name [ COLLATE collation ] [ opclass ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ] }[, ...] ) 
    [CONTAINING (containing_colname)] [DISTRIBUTE BY hash(dist_colnames)]
    [ TABLESPACE tablespace_name ];
support.huaweicloud.com/distributed-devg-v3-gaussdb/gaussdb-12-0520.html