华为GaussDB A 分区索引创建和修改

--创建分区表索引HR_staffS_p1_index1，不指定索引分区的名字。

CREATE INDEX HR_staffS_p1_index1 ON HR.staffS_p1 (staff_ID) LOCAL;

--创建分区索引HR_staffS_p1_index2，并指定索引分区的名字。

CREATE INDEX HR_staffS_p1_index2 ON HR.staffS_p1 (staff_ID) LOCAL

(

    PARTITION staff_ID1_index,

    PARTITION staff_ID2_index TABLESPACE example3,

    PARTITION staff_ID3_index TABLESPACE example4

) TABLESPACE example;

CREATE INDEX HR_staffS_p1_index2 MOVE PARTITION staff_ID2_index TABLESPACE example1;

ALTER SESSION SET CURRENT_SCHEMA TO hr;

ALTER INDEX HR_staffS_p1_index2 MOVE PARTITION staff_ID2_index TABLESPACE example1;