Subject Re: [firebird-support] choosing best index
Author Ann Harrison
p_lerner wrote:

>Hi, where can I find information about how to choose the best index
>for a query ?
Errr... that's sort of what the optimizer is for.

>Is it faster to index each field or to make composite indexes
>according to the query ?
Probably index each field unless there is some compelling reason (e.g.
uniqueness) for creating a compound index.