为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:centos7
【CPU】:x86
【问题描述】*:
源oracle中主要是通过dba_part_indexes这个视图来过滤本地索引,但是达梦这边本地索引和全局索引怎么过滤的?
这是源oracle中package的sql语句:
SELECT c.table_owner,
c.table_name,
c.index_name,
c.column_name,
d.COLUMN_ID,
c.column_position
FROM dba_ind_partitions a,
dba_part_indexes b,
dba_ind_columns c,
dba_tab_columns d
WHERE a.index_owner = b.owner
AND a.index_name = b.index_name
AND b.owner = c.index_owner
AND b.index_name = c.index_name
AND b.table_name = c.table_name
AND a.partition_name = '外部参数'
AND b.table_name = '外部参数'
AND c.table_owner = '外部参数'
AND c.table_owner = d.OWNER
AND c.table_name = d.TABLE_NAME
AND c.column_name = d.COLUMN_NAME
AND b.locality = 'LOCAL'
SELECT c.table_owner, c.table_name, c.index_name, c.column_name, d.COLUMN_ID, c.column_position FROM dba_ind_partitions a, dba_indexes b, dba_ind_columns c, dba_tab_columns d WHERE a.SCH_NAME = b.owner AND a.index_name = b.index_name AND b.owner = c.index_owner AND b.index_name = c.index_name AND b.table_name = c.table_name AND a.partition_name = 'PART_01' AND b.table_name = 'TB_PART' AND c.table_owner = 'TEST' AND c.table_owner = d.OWNER AND c.table_name = d.TABLE_NAME AND c.column_name = d.COLUMN_NAME AND b.partitioned='YES'