[Firebird-devel] Covering index?

2013-01-27 Thread Thomas Steinmaurer
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

Re: [Firebird-devel] Covering index?

2013-01-27 Thread Dimitry Sibiryakov
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