Re: Why is PCTUSED not used for index?

In article <ug0at7s6i.fsf_at_verizon.net>, Galen says...
>
>On 14 Aug 2001, tkyte_at_us.oracle.com wrote:
>
>> Blocks from an index only get onto the freelist when they are
>> 100% empty -- else they are left where they are in the data
>> structure that is the index. They are candidates for insertion
>> even when they are NOT on the freelist (unlike tables, there a
>> block must be on the freelist or above the high water mark to
>> be a candidate for insertion).
>
>So, for an index, a freelist is really just a listing of all the
>blocks that are currently being used for holding the index? They
>are sort of misnamed in this case, but suffice for their usage?

no, a freelist for an index is the list of all blocks that currently have nothing on them - they were once part of the index but are no longer in the data structure (they are totally empty)

>--
>Galen Boyer
>It seems to me, I remember every single thing I know.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp