Advantages and disadvantages of composite indexes

Composite indexes have these advantages:

Good choices for composite indexes are:

The disadvantages of composite indexes are:

Poor choices are: