-- 由于风险排查申诉,同一个风险排查任务号和同一保单下可能会存在多个保全项,故删除该唯一索引
declare
num1 int;
BEGIN
select count(1) into num1 from user_ind_columns where index_name=('UNI_RI_RESCISSION_FEE');
if num1 >=1 then
Execute immediate 'DROP INDEX UNI_RI_RESCISSION_FEE';
ELSE
dbms_output.PUT_LINE('索引不存在');
end if;
end;
-- 增加风险解约费用表的联合索引,普通类型
declare
num1 int;
BEGIN
select count(1) into num1 from user_ind_columns where index_name=('IDX_RI_FEE_TASK_ID_POLICY_ID');
if num1 >=1 then
dbms_output.PUT_LINE('索引已存在');
ELSE
Execute immediate 'CREATE INDEX IDX_RI_FEE_TASK_ID_POLICY_ID ON T_RI_RESCISSION_FEE
(TASK_ID, POLICY_ID) online';
end if;
end;