/**Begin D:\PDM\PDM_UPGRADE\pdm1\BCM_constraint.sql **/
EXEC p_DropIdx 'IDX_BCM_MDDATA_SEL', 'T_BCM_MDDATA';

IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BCM_MDDATA_SEL') CREATE INDEX IDX_BCM_MDDATA_SEL ON T_BCM_MDDATA ( FENTITY ,FFY ,FPERIOD ,FCURRENCY );

IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BCM_LGMDDATA_QUERY') CREATE INDEX IDX_BCM_LGMDDATA_QUERY ON T_BCM_LGMDDATA ( FCOMPANYCODE ,FYEAR ,FPERIOD ,FCURRENCY );

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