openGauss 创建索引

创建唯一索引
create unique index t1_fn_idx on t1(relfilenode); 

创建复合索引
create index t1_owner_tbs_idx on t1(relowner,reltablespace);

创建部分索引
create index t1_lttbs_idx on t1(reltablespace) where reltablespace<20; 

创建函数索引
create index t1_upname_idx on t1(upper(relname)); 

创建分区表的本地索引
create index pt1_id_idx on pt1(id) local; 

创建分区表的全局索引
create index pt1_score_idx on pt1(score) global tablespace tbs1; 

修改索引
alter index t1_fn_idx rename to t1_fn_idx2;
alter index t1_fn_idx2 set tablespace tbs2;
alter index t1_lttbs_idx unusable;
alter index t1_lttbs_idx rebuild;

修改分区索引
alter index pt1_id_idx rebuild partition p1_id_idx;
alter index pt1_id_idx modify partition p1_id_idx unusable;
alter index pt1_id_idx rename partition p1_id_idx to p1_id_idx2;
alter index pt1_id_idx move partition p1_id_idx2 tablespace tbs1;

删除索引
drop index t1_lttbs_idx;