Re: Why is PCTUSED not used for index?

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?

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