Subject Re: Re: [firebird-support] Composite index - issue or not existing feature?
Author liviuslivius

HTH (even though it may be overly simplified),

(*) In theory with the exception of 'borderline performance issues', were single field indexes are too slow, whereas multifield indexes are quick enough. Though I have to say that I work on smaller databases than you do and never have experienced this (I prefer simplicity over - let me make a wild guess - 20% performance improvement).
The last point is the essential 20% performance improvement
but i also know that Firebird do really good job on "bitmap or" and "bitmap and" operation on indexes, and it uses many indexes in one query very well.
Karol Bieniaszewski