/**Begin D:\PDM\PDM_UPGRADE\pdm1\BCM_constraint.sql **/
EXEC p_DropIdx 'IDX_BCM_DISTRIBUTION_MODELID', 'T_BCM_DISTRIBUTION';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BCM_DIS_QUERY') CREATE INDEX IDX_BCM_DIS_QUERY ON T_BCM_DISTRIBUTION ( FMODEL ,FTEMPLATE );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BCM_CHKRPT_QUERYNEW') CREATE INDEX IDX_BCM_CHKRPT_QUERYNEW ON T_BCM_CHKREPORT ( FMODEL ,FSENCE ,FYEAR ,FPERIOD ,FCURRENCY );

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