Ken Walters wrote:
>
> >A browned index should be dropped and rebuilt. Determining Index Browning
> >
> >The number and length of deleted leaf nodes to the total leaf node length and
> >number are important ratios to be considered. These can be calculated as:
> >
> >
> >% of Leaf Node Length is deleted =
> > del_lf_rows_len / ( del_lf_rows_len + lf_rows_len )
> >
> >% of Leaf Nodes are deleted =
> > del_lf_rows / ( del_lf_rows + lf_rows )
> >
> >-----== Posted via Deja News, The Leader in Internet Discussion ==-----
> >http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
> I am sill not clear on exactly how to go about determining if an index
> is excessively "brown". Which system catalogs do I look at? What
> columns do I reference? What is the calculation?
> I have some software that tells me most of my indexes need to be
> rebuilt even when they are brand new. I have been looking for some
> solid advice on this issue.
> Thanks in advance.
>
> --
> Ken Walters
> kwalters_at_pbs.org
> DBA
> Public Braodcasting Service
> kwalters_at_pbs.org
When you analyse your index look for this information in index_stats.
Received on Fri Sep 18 1998 - 12:30:07 CDT
