Re: How to estimate index sizing ?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 5 Jul 2002 16:56:29 +1000
Message-ID: <6kbV8.27909$Hj3.86532@newsfeeds.bigpond.com>

That's because it's not in there. Validate Structure the index and look in index_stats, all the leaf_rows_len type stuff is in there (if you have permissions).

The number of leaf_blocks in user_indexes should help with any ball park figures providing proportion of data, data key distributions, compression are known or similar.

Good Luck

Richard

"yewpc" <member_at_dbforums.com> wrote in message news:3d253a04$1_at_usenetgateway.com...
> Hi all,
>
> If i have some sample data for table, i can actually use it for my
> table and index sizing by using analyze command.
>
> For table, i can use user_tables.avg_row_len * estimate row for my
> table after anayze the table.
>
> For index, how do i get the avg_row_len ? i can't find it from
> user_indexes.
>
> Can anyone tell me how ?
>
> Thank you
>
> Regards, ypc
>
>
>
> --
> Posted via dBforums
> http://dbforums.com
Received on Fri Jul 05 2002 - 01:56:29 CDT