Subject RE: [firebird-support] Question about Firebird indexes
Author Sasha Matijasic
> I simply want to index two columns of my table, so when I search
> SEPARATELY for either DocumentTypeID or DocumentType, I want the SELECT
> to be as fast as possible. Which is the road to take?

Firebird will use your compound indexes if you search for single columns, so I guess it doesn't matter what approach you choose. There might be some gotchas other people might know of.