Re: Easy way to get size of an index?

Try something like:

select segment_name, sum(bytes) bytes
from dba_segments
where segment_name = <YOUR_INDEX>
and owner = <YOUR_OWNER>;

Also check the "Sever Reference Manual" for a *brief* explanation of the dba_* views.

Sincerely,
Maury Received on Sun Oct 24 1999 - 17:30:22 CDT