IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_FA_CHANGEBILLREALENTRY' AND KSQL_INDNAME = 'IDX_FA_REALENTRY')
CREATE INDEX IDX_FA_REALENTRY ON T_FA_CHANGEBILLREALENTRY (FAFTREALCARDID ,FID );