Subject Re: Any advantage of a Compound Index across two already indexed fields?
Author Adam
--- In, "Dimitry Sibiryakov" <SD@...>
> On 30 May 2006 at 6:39, Adam wrote:
> >1. Given that Firebird is capable of combining both of those indices,
> >is there any benefit to creating a compound key across them?
> Indexes are not a target but a tool. The answer depends on queries
> you perform against the table.

OK then, in your terms then

I have several options of which tools I can use

create index ix_tablea_1 on tablea (field1);
create index ix_tablea_2 on tablea (field2);


create index ix_tablea_3 on tablea (field1, field2);

Obviously there are queries which the first two indices can help with
that the third can not. 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