Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBA Tip of the Month: Index Browning

Re: DBA Tip of the Month: Index Browning

From: Ken Walters <kwalters_at_pbs.org>
Date: Fri, 18 Sep 1998 14:52:42 GMT
Message-ID: <360272af.871072205@nntp.pbs.org>

>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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US