/**Begin D:\PDM_UPGRADE\PDM1\BCM_constraint.sql **/
EXEC p_DropIdx 'IDX_BCM_CHKRPT_QUERY', 'T_BCM_CHKREPORT';
EXEC p_DropIdx 'IDX_BCM_CHKRPT_QUERYNEW', 'T_BCM_CHKREPORT';
EXEC p_DropIdx 'IDX_BCM_CHKRPT_PHASE', 'T_BCM_CHKREPORT';
 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 ,FPROCESSLD ,FPERIOD ,FYEAR ,FCURRENCY ,FMODEL ,FSENCE );


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