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