>>>>> "MM" == Mike Matrigali <[EMAIL PROTECTED]> writes:

    MM> Derby will also reclaim space automatically in btree indexes for this
    MM> case as long as all the old rows on a given leaf are deleted and
    MM> the background process gets a chance to get a table level lock
    MM> at some point - the current algorithm requires a table level lock
    MM> to do the index management to delete an entire leaf from the tree.

What about non-leaf pages of the B-Tree?

-- 
�ystein

Reply via email to