Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Why is PCTUSED not used for index?

Re: Why is PCTUSED not used for index?

From: Keith Boulton <kboulton_at_ntlunspam-world.com>
Date: Wed, 15 Aug 2001 11:52:31 +0100
Message-ID: <Qpse7.32755$zs.314407@news11-gui.server.ntli.net>


> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US