查看索引占用空间大小:
select (sum(bytes)/1024/1024)||'MB' from dba_segments where segment_name = 'PK_EMP';
170MB
查看表占用空间大小
select (sum(bytes)/1024/1024)||'MB' from dba_segments where segment_name = 'EMP';
2100MB
170/2100= 8% , 由此得出索引占表的8%左右的空间
转载于:https://www.cnblogs.com/hankyoon/p/5174520.html