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 ------------------------------------------------------------------------------ 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
