Exactly what are "leaf_blocks"??? Script included.

From: Steve Orr <SteveOrr_at_TechWise.com>
Date: Thu, 6 Aug 1998 21:10:18 -0700
Message-ID: <6qduqh$jd4@masters0.InterNex.Net>

The DBA_INDEXES view has a column called "leaf_blocks." What EXACTLY is that? Is that the number database blocks occupied by index data? If so does the following query give the number of unused blocks left in the current storage allocation for the index? (Assuming compute statistics has been performed.)

select dba_indexes.index_name,

       dba_segments.blocks - dba_indexes.leaf_blocks -1 from dba_segments, dba_indexes

where  dba_indexes.index_name = dba_segments.segment_name
and    dba_indexes.owner = dba_segments.owner
and    dba_segments.segment_type='INDEX'
and    dba_indexes.index_name = <whatever>;

----------------------------------

Any ideas??? Thanks in advance... Received on Thu Aug 06 1998 - 23:10:18 CDT