/**Begin D:\DBA\PDM_UPGRADE\PDM1\BCM_constraint.sql **/

EXEC p_DropIdx 'IDX_BCM_ADJMODEL', 'T_BCM_RPTADJUST';
EXEC p_DropIdx 'IDX_BCM_ADJPROCESS', 'T_BCM_RPTADJUST';
EXEC p_DropIdx 'IDX_BCM_ADJPROCESS_JBU', 'T_BCM_RPTADJUST';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BCM_ADJUSTDIM') CREATE INDEX IDX_BCM_ADJUSTDIM ON T_BCM_RPTADJUST ( FMODELID ,FSCENEID ,FYEARID ,FPERIODID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BCM_ADJUSTNUMBER') CREATE INDEX IDX_BCM_ADJUSTNUMBER ON T_BCM_RPTADJUST ( FNUMBER );


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