IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SIM_ISOMERISM_VOUCHERNO') CREATE INDEX IDX_SIM_ISOMERISM_VOUCHERNO ON T_SIM_ISOMERISM_BILL_DATA ( FVOUCHER_NO );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SIM_ISOMERISM_EXTRACTEDCODE') CREATE INDEX IDX_SIM_ISOMERISM_EXTRACTEDCODE ON T_SIM_ISOMERISM_BILL_DATA ( FEXTRACTED_CODE );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SIM_ISOMERISM_BILLDATE') CREATE INDEX IDX_SIM_ISOMERISM_BILLDATE ON T_SIM_ISOMERISM_BILL_DATA ( FBILL_DATE );