/**Begin D:\PDM\PDM_UPGRADE\pdm1\BCM_constraint.sql **/
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BCM_TEMPLATE_MODELID') CREATE INDEX IDX_BCM_TEMPLATE_MODELID ON T_BCM_TEMPLATE ( FMODELID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BCM_RPT_TMPLID') CREATE INDEX IDX_BCM_RPT_TMPLID ON T_BCM_REPORT ( FTEMPLATEID ,FFYID ,FPERIODID ,FSTATUS );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BCM_CHKRPT_QUERY') CREATE INDEX IDX_BCM_CHKRPT_QUERY ON T_BCM_CHKREPORT ( FORG ,FPERIOD ,FYEAR ,FCURRENCY ,FCHKFORMULAID );

/**End D:\PDM\PDM_UPGRADE\pdm1\BCM_constraint.sql **/
