| Subject | Re: [firebird-support] Re: Any advantage of a Compound Index across two already indexed fields? |
|---|---|
| Author | Dmitry Yemanov |
| Post date | 2006-05-30T07:41:40Z |
"Adam" <s3057043@...> wrote:
performs slightly (10-50%) better.
Dmitry
>If both index segments are used for equality matching, then a compound index
> 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?
performs slightly (10-50%) better.
Dmitry