If you want the number of bytes you can query dba/user/all_segments. If you
want the number of rows you can query dba/user/all_indexes. HTH Ruth
----- Original Message -----
From: ALEMU Abiy <abiy.alemu_at_criltechnology.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Wednesday, May 03, 2000 9:55 AM
Subject: Actual index sizes
> I would like to know which system table to consult to know the actual size
> of an index. Can you please correct me if I'm mistaken by saying that the
> size of an index varies with respect to the number of rows in the the
table
> ?
>
> I need your help friends !!!
> --
> Author: ALEMU Abiy
> INET: abiy.alemu_at_criltechnology.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed May 03 2000 - 10:06:51 CDT
