Always create indexes that are intended to being compared through equality first, and through greater/lower than (or between) last (and just that final one, since including any further columns will generally not assist with any query of this nature).