Re: Index rebuilds

On Thu, 09 Oct 2003 08:18:43 +0000, Norman Dunbar wrote:

> On Thu, 09 Oct 2003 06:12:37 +1000, Howard J. Rogers wrote:
>

<SNIP>

> you might at some point have to rebuild the index because the sequence is
> generating an increasing value each time so a row (or rows) that have been
> deleted will NEVER be reused because the indexed column, generated by the
> sequence, is always a higher value.
>
> Of course, if the deleted row is in the current index block (the one where
> ALL the inserts are taking place) then the deleted index entry can be
> reused, but only while that block remains current.
>

Oops - missed a bit, if you delete all the entries in an index block, then that block will be reused.

-- 
Delete the obvious bit from my email address to reply by email.