创建索引

 

普通索引

create indes "schema"."indexName" on "schema"."tableName"

("字段1" asc, "字段2" asc)

compress no allow reverse scans;

唯一索引

create unique index "schema"."indexName" on "schema"."tableName"

("字段" asc)

xompress no allow reverse scans;

主键约束索引

alter table "schema"."tableName"

add constraint "pk_indexName" primary key

("inst_id");