Choosing the order of columns in an index
It's kind of scary to see someone else put down thought processes that could have been your own. That's what Gail did with this post. It's worth a close read because it's offering very good advice and supplying the reasoning behind that advice.