Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why is PCTUSED not used for index?
> Because things are stored in order, then the only time space could be
> reused if a value that was previously deleted is reinserted, or all the
> entries in a block are removed - at which point the entire block becomes
> re-available - thus obviating the need for a pctused concept.
>
> hth
> connor
This is only correct because near-empty blocks are not automatically coalesced. One could easily imagine an automatic coalesce which considered a pctused parameter in its calculations. Received on Wed Aug 15 2001 - 05:52:31 CDT