Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBA Tip of the Month: Index Browning
>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
Received on Fri Sep 18 1998 - 09:52:42 CDT