I.lib()/I.lib(Altibase)
알티베이스 인덱스 사용 공간 조회
.07274.
2010. 12. 8. 02:08
select a.name index_space_name ,d.table_name table_name , e.user_name user_name , b.index_name index_name
from v$tablespaces a , system_.SYS_INDICES_ b , v$index c , system_.SYS_TABLES_ d , system_.sys_users_ e
where a.id=b.tbs_id and b.index_id=c.INDEX_ID and b.table_id = d.table_id and b.user_id = e.user_id
from v$tablespaces a , system_.SYS_INDICES_ b , v$index c , system_.SYS_TABLES_ d , system_.sys_users_ e
where a.id=b.tbs_id and b.index_id=c.INDEX_ID and b.table_id = d.table_id and b.user_id = e.user_id