ORACLE/ADMIN
index 정보 조회
[PineTree]
2009. 3. 20. 11:11
반응형
인덱스 정보 보기
select a.index_name,b.table_name,column_name,COLUMN_POSITION,UNIQUENESS,tablespace_name,table_owner
from ind a, USER_IND_COLUMNS b
where a.index_name=b.index_name
order by a.index_name,COLUMN_POSITION
select a.index_name,b.table_name,column_name,COLUMN_POSITION,UNIQUENESS,tablespace_name,table_owner
from ind a, USER_IND_COLUMNS b
where a.index_name=b.index_name
order by a.index_name,COLUMN_POSITION
반응형