/**Begin D:\PDM_UPGRADE\PDM1\HPDI_constraint.sql **/
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HPDI_BIZDATA_EMPITEMEFF') CREATE INDEX IDX_HPDI_BIZDATA_EMPITEMEFF ON T_HPDI_BIZDATA ( FEMPPOSORGRELID ,FBIZITEMID ,FEFFECTIVEDATE );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HPDI_BIZDATABILLDETAIL_IE') CREATE INDEX IDX_HPDI_BIZDATABILLDETAIL_IE ON T_HPDI_BIZDATABILLDETAIL ( FBIZITEMID ,FEFFECTIVEDATE );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HPDI_BIZDATABILLENT_EMP') CREATE INDEX IDX_HPDI_BIZDATABILLENT_EMP ON T_HPDI_BIZDATABILLENT ( FEMPPOSORGRELID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HPDI_BIZDATABILLENT_ID') CREATE INDEX IDX_HPDI_BIZDATABILLENT_ID ON T_HPDI_BIZDATABILLENT ( FID );


/**End D:\PDM_UPGRADE\PDM1\HPDI_constraint.sql **/
