[Firebird-devel] "Covering" index?

[Thomas S. <ts...@ib...>]

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 serve result fields directly out of an index without going 
to the underlaying table data?

For example (name is an indexed field):

select name from t1 where name like 'Hugo%'


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?


Thanks,
Thomas