db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Oystein.Grov...@Sun.COM (Øystein Grøvlen)
Subject Re: Behaviour of SYSCS_COMPRESS_TABLE
Date Thu, 02 Jun 2005 08:00:22 GMT
>>>>> "MM" == Mike Matrigali <mikem_app@sbcglobal.net> 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


Mime
View raw message