IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_ER_PLANEBILL' AND KSQL_INDNAME = 'IDX_ER_PBILL_COMPLEX')
CREATE INDEX IDX_ER_PBILL_COMPLEX ON T_ER_PLANEBILL (FTRAVELERNAME ,FFLIGHTNO ,FTAKEOFFTIME );

IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_ER_TRAINBILL_A' AND KSQL_INDNAME = 'IDX_ER_TRAINBILL_A_COMPLEX')
CREATE INDEX IDX_ER_TRAINBILL_A_COMPLEX ON T_ER_TRAINBILL_A (FVENDORNAME ,FDEPARTADDRESS ,FARRIVEADDRESS ,FDEPARTTIME );
