Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ACTUAL INDEX SIZE
hello
to estimate the size of a index try :
(sizeofindex [sum(size of columns in index)] +11 ) * number of rows
with sql:
select sum(bytes) from user_extents where segment_name=<name of your index>
good luck
Wesley <wesleyto_at_my-deja.com> a écrit dans le message :
7thrhb$dqr$1_at_nnrp1.deja.com...
> Hi,
>
> Could anyone tell me how to calculate the actual size occupied by
> an index?
>
> TIA.
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Oct 08 1999 - 17:48:39 CDT