Similar indexes - do I need both?

[bunner_bob]

I have some queries that include 3 columns of a particular table in their WHERE statement:

State
UserID
Type

and other queries that only use 2 of these columns:

UserID
Type

Should I create two separate indexes, or just one? If one, should it be on all 3 columns, or just UserID and Type?

Also, does the order of columns in the index make any difference?

• Bob