| Subject | RE: [firebird-support] Question about Firebird indexes |
|---|---|
| Author | Sasha Matijasic |
| Post date | 2008-07-01T08:16:48Z |
>Hi,
> 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.
Sasha