select i.index_name
, i.tablespace_name
, ceil(s.bytes / 1048576) "Size MB"
from dba_indexes i
, dba_segments s
where i.index_name = s.segment_name
and table_name like '&table'
order by 2, 1
/
Show indexed columns
select column_name
from dba_ind_columns
where index_name = '&index'
order by column_position
/
