On Mon, Jan 28, 2013 at 11:42 AM, Dimitry Sibiryakov <s...@ibphoenix.com>wrote:
> 28.01.2013 17:27, Thomas Steinmaurer wrote:
> > How does the engine know when to garbage collect an index
> > entry?
>
> When list of record references in it is empty.
>
> -
Expanding again, when Firebird garbage collects a record version, it checks
keys for all the indexes on the record, building a list of "staying and
going" values - values that are, or are not, duplicated in other versions
of the same record. It then removes the index entries for the "going"
values.
Cheers,
Ann
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
