Re: rebuild indexes

Jonathan:

Thanks for the reply.

My question was whether or not does blks_gets_per_key become initialized when the index is either rebuilt or recreated?

Apparently not but I just wanted to confirm this.

Thanks.

David Spaisman
Jonathan Lewis wrote in message
<931118614.7279.0.nnrp-12.9e984b29_at_news.demon.co.uk>...
>
>As I wrote a couple of weeks ago:
>blks_gets_per_key is roughly half the average number
>of rows per key plus a few. Specifically it is:
> (index height + (number of leaf rows /(2 * number of distinct keys))
>
>Example:
> 10,000 rows in table
> 100 different key values
> Index height 3
>
>bgpa will be:
> 3 + (10,000 / (2 * 100)) = 53.
>
>It has no bearing on the efficient use of storage,
>it just just a (fairly poor) measure of whether the
>index should exist or not.
>
>--
>
>Jonathan Lewis
>Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
>David Spaisman wrote in message
><7lislb$c88$1_at_mailint03.im.hou.compaq.com>...
>>Hello:
>>
>>I have been told that the two parameters -- blks_gets_per_access and
>>pct_ued -- were key indicators on whether or not an index should be
>rebuilt.
>>
>
>
>
Received on Tue Jul 06 1999 - 11:45:53 CDT