/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\EB_table.sql **/

-- 描述：视图选择成员索引
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_EB_MEMBERSAVESELECT_V')
CREATE INDEX IDX_EB_MEMBERSAVESELECT_V ON T_EB_MEMBERSAVESELECT ( FVIEWID );


-- 描述：数据集成成员映射视图索引
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_EB_INTEGRATION_V')
CREATE INDEX IDX_EB_INTEGRATION_V ON T_EB_INTEGRATION_MAP ( FDIMVIEW );


-- 维度视图创建parentid索引
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_EB_DIMENSIONVIEW_P')
CREATE INDEX IDX_EB_DIMENSIONVIEW_P ON T_EB_DIMENSIONVIEW ( FPARENTID );


/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\EB_table.sql **/