# 특정 테이블의 인덱스 조회하기
col INDEX_OWNER for a10
col INDEX_NAME for a15
col TABLE_OWNER for a10
col TABLE_NAME for a15
col COLUMN_NAM for a15
SELECT A.uniqueness,
b.*
FROM ALL_INDEXES a,
ALL_IND_COLUMNS b
WHERE a.index_name = b.index_name
AND a.table_name=upper(‘[TABLE_NAME]’);
ex)
SELECT A.uniqueness,
b.*
FROM ALL_INDEXES a,
ALL_IND_COLUMNS b
WHERE a.index_name = b.index_name
AND a.table_name=upper(‘BONUS’);
실행 결과
# 특정 유저의 인덱스 조회하기
select object_name, object_type
from dba_objects
where owner=’SCOTT’ and object_type = ‘INDEX’ ;
