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.