查看某张表的索引结构
WITH IND AS (
SELECT DISTINCT A.TABLE_OWNER,
A.TABLE_NAME,
A.INDEX_OWNER,
A.INDEX_NAME,
LISTAGG(A.COLUMN_NAME, ',') WITHIN GROUP(ORDER BY COLUMN_POSITION)
OVER(PARTITION BY A.TABLE_OWNER, A.TABLE_NAME, A.INDEX_OWNER, A.INDEX_NAME) IND_COLUMNS
FROM DBA_IND_COLUMNS A
WHERE
A.TABLE_NAME = '&table_name' )
SELECT X.*, B.INDEX_TYPE,B.UNIQUENESS
FROM IND X , DBA_INDEXES B
WHERE X.INDEX_OWNER = B.OWNER
AND X.INDEX_NAME = B.INDEX_NAME;
WITH IND AS (
SELECT DISTINCT A.TABLE_OWNER,
A.TABLE_NAME,
A.INDEX_OWNER,
A.INDEX_NAME,
LISTAGG(A.COLUMN_NAME, ',') WITHIN GROUP(ORDER BY COLUMN_POSITION)
OVER(PARTITION BY A.TABLE_OWNER, A.TABLE_NAME, A.INDEX_OWNER, A.INDEX_NAME) IND_COLUMNS
FROM DBA_IND_COLUMNS A
WHERE
A.TABLE_NAME = '&table_name' )
SELECT X.*, B.INDEX_TYPE,B.UNIQUENESS
FROM IND X , DBA_INDEXES B
WHERE X.INDEX_OWNER = B.OWNER
AND X.INDEX_NAME = B.INDEX_NAME;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/308563/viewspace-2136317/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/308563/viewspace-2136317/