And the rest of the article.... or was that it?
info_at_revealnet.com wrote in article <6trts4$rev$1_at_nnrp1.dejanews.com>...
> From the DBA Pipeline, a free internet community for Oracle DBAs
worldwide.
> Join the Pipelines for focused technical discussions, free white papers &
> utilities, tips and more. The DBA Pipeline is hosted by author Mike Ault
and
> sponsored by RevealNet. http://www.revealnet.com/pipeline.htm Enjoy!
>
-
> ---------------------- September's Tip of the Month
>
> Index Maintenance
>
> Index browning is the process where btrieve leaf nodes are deleted
leaving
> holes in the index. Under the btrieve structure the vacancies left by
data
> deletion aren't filled. Using the analagy of a tree it is as if the leaf
has
> turned brown because it is dead.
>
> If an index shows excessive browning it will impact performance due to
the
> large number of transversals required to find the required values.
>
> 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
>
Received on Fri Sep 18 1998 - 19:34:17 CDT