EXEC p_DropIdx 'IDX_CAS_BJ_FBankAcctID', 'T_CAS_BANKJOURNAL';
EXEC p_DropIdx 'IDX_PAYMENTBILL_E_FPaymentCnel', 'T_CAS_PAYMENTBILL_E';
EXEC p_DropIdx 'IDX_CAS_PB_FOrgID', 'T_CAS_PAYMENTBILL';
EXEC p_DropIdx 'IDX_CAS_BS_BCC', 'T_CAS_BANKSTATEMENT';
EXEC p_DropIdx 'IDX_CAS_BJ_BCC', 'T_CAS_BANKJOURNAL';
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_CAS_BJ_BCC') CREATE INDEX IDX_CAS_BJ_BCC ON T_CAS_BANKJOURNAL ( FBANKACCTID ,FCURRENCYID ,FBIZDATE );