Subject Re: [firebird-support] Re: Any advantage of a Compound Index across two already indexed fields?
Author Dmitry Yemanov
"Adam" <s3057043@...> wrote:
> My question is, what benefit would there EVER
> be in declaring the third index given that you could alternatively
> declare ix_tablea_1 and ix_tablea_2 for the same benefit but more
> flexibility?

If both index segments are used for equality matching, then a compound index
performs slightly (10-50%) better.