On Sun, Jan 27, 2013 at 3:23 PM, Dimitry Sibiryakov s...@ibphoenix.com
mailto:s...@ibphoenix.com wrote:
27.01.2013 21:17, Thomas Steinmaurer wrote:
Is Firebird able here to serve the result here out of the index
or does
it need to lookup data by following the index key
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.
Thanks.
Regards,
Thomas
--
Master Visual Studio,
Hello,
SQL Server supports something called covering index, which basically
means, that additional columns can be added to the index definiton,
which aren't in the index key then, but at index lead level only.
I know Firebird doesn't support something like that, but I wonder if
Firebird can
27.01.2013 21:17, Thomas Steinmaurer wrote:
Is Firebird able here to serve the result here out of the index or does
it need to lookup data by following the index key to the row data?
There is no data in index. And no information about transaction created an
index entry.
So, yes, Firebird
