为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8.0
【操作系统】:win11
【CPU】:
【问题描述】*:如何获取表数据中索引的详细信息
select * from dba_indexes where table_name='Test2';
select TS_OBJ.* from (select * from (SELECT * from SYS.V$TABLESPACE where true) where true ) TS_OBJ ORDER BY NAME;
select COLS.NAME, COLS.TYPE$, SF_GET_INDEX_KEY_ORDER(INDS.KEYNUM, INDS.KEYINFO, COLS.COLID), SF_GET_INDEX_KEY_SEQ(INDS.KEYNUM, INDS.KEYINFO, COLS.COLID) SEQ from SYSCOLUMNS COLS, SYSINDEXES INDS where INDS.ID = 33555808 and COLS.ID = 1188 and SF_COL_IS_IDX_KEY(INDS.KEYNUM, INDS.KEYINFO, COLS.COLID) = 1 order by SEQ;
select name, type$,* from syscolumns where id = 1188;
这4条sql基本可以获取详细数据,但是找不到对应的【函数索引,空间索引,数据索引,反向索引】的信息
可以查看下SYSINDEXES
