CREATE BITMAP  INDEX "idx_cus_indiv_cusno_coopno" ON "REC_LOAN_LAST"."cus_indiv"("cust_no" ASC,"coop_no" ASC)  ;
CREATE  INDEX "idx_cus_base_info_cert_no" ON "REC_LOAN_LAST"."cus_base_info"("cert_no" ASC) ;
CREATE  INDEX "idx_fac_duebill_prin_over_days" ON "REC_LOAN_LAST"."fac_loan_duebill"("prin_over_days" ASC) ;
CREATE  INDEX "idx_pay_credit_app_payout_date" ON "REC_LOAN_LAST"."pay_credit_app"("payout_date" ASC) ;
CREATE  INDEX "idx_pay_credit_app_maturity_date" ON "REC_LOAN_LAST"."pay_credit_app"("maturity_date" ASC) ;
CREATE  INDEX "idx_pay_credit_app_prd_code" ON "REC_LOAN_LAST"."pay_credit_app"("prd_code" ASC) ;
CREATE  INDEX "idx_pay_credit_app_appsts" ON "REC_LOAN_LAST"."pay_credit_app"("app_sts" ASC) ;
CREATE  INDEX "idx_pay_credit_app_transts" ON "REC_LOAN_LAST"."pay_credit_app"("tran_sts" ASC) ;
CREATE BITMAP  INDEX "idx_cus_indiv_cusno_chancode" ON "REC_LOAN_LAST"."cus_base_info"("cust_no" ASC,"chan_code" ASC)  ;
CREATE  INDEX "idx_ln_ac_sts" ON "REC_LOAN_LAST"."fac_loan_duebill"("loan_acc_sts" ASC,"id" DESC) ;
CREATE  INDEX "idx_fac_duebill_payout_date" ON "REC_LOAN_LAST"."fac_loan_duebill"("payout_date" ASC) ;
CREATE  INDEX "idx_fac_duebill_payoff_date" ON "REC_LOAN_LAST"."fac_loan_duebill"("payoff_date" ASC) ;


-- 20230803新增
CREATE  INDEX "idx_cus_base_info_create_time" ON "REC_LOAN_LAST"."cus_base_info"("create_time" desc)
CREATE UNIQUE  INDEX "idx_fac_loan_duebill_dueno" ON "REC_LOAN_LAST"."fac_loan_duebill"("duebill_no" ASC)