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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_T_BCM_MEMBERMAPENTITY') CREATE INDEX IDX_T_BCM_MEMBERMAPENTITY ON T_BCM_MEMBERMAPENTITY ( FMODELID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_T_BCM_MEMBERMAP') CREATE INDEX IDX_T_BCM_MEMBERMAP ON T_BCM_MEMBERMAPENTITY ( FBCMDIMID ,FBCMMEMBER );



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