RE: Explanation of index statistics

From: Naveen, Nahata (IE10) <Naveen.Nahata_at_honeywell.com>
Date: Fri, 14 May 2004 05:55:44 -0700
Message-ID: <77ED2BF75D59D1439F90412CC5B109740BE4664E@ie10-sahara.hiso.honeywell.com>

>LF_ROWS LF_BLKS LF_ROWS_LEN LF_BLK_LEN BR_ROWS
>BR_BLKS BR_ROWS_LEN
>106536 6465 2450320 3540 6464
>157 122626
>BR_BLK_LEN DEL_LF_ROWS DEL_LF_ROWS_LEN DISTINCT_KEYS MOST_REPEATED_KEY
> 3932 106533 2450251 30847
> 18
>
>BTREE_SPACE USED_SPACE PCT_USED ROWS_PER_KEY
>BLKS_GETS_PER_ACCESS PRE_ROWS
> 23503424 2572946 11 3.4536908
>5.2268454 0
>PRE_ROWS_LEN OPT_CMPR_COUNT OPT_CMPR_PCTSAVE
> 0 2 28
>
>How do these numbers match to such a small table (at the time
>of the analyze)?

LF_ROWS - DEL_LF_ROWS (106536 - 106533 = 3) is the total no. of index entries pointing to table rows in the index. Since the total rows in the table as per you is 10, the index should be on a NULLABLE column.

Deleted index entries keep appearing in the INDEX_STATS until

They are re-used
The index is re-built

Regards
Naveen

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Sat May 15 2004 - 09:57:49 CDT