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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BCM_PERIODMANAGE_QUERY') CREATE INDEX IDX_BCM_PERIODMANAGE_QUERY ON T_BCM_PERIODMANAGEENTITY ( FMODELID ,FORGNUMBER ,FSCENARIOID ,FYEARID ,FPERIODID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BCM_CHKNOTEINFO_TYPE') CREATE INDEX IDX_BCM_CHKNOTEINFO_TYPE ON T_BCM_CHKNOTEINFO ( FMODEL ,FTYPE );


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