Efficient Compound Index Usage

Discusses the importance of columns used in a where clause with a compound index. Shows how the order of your columns within a compound index can impact performance. Gives tips on how to properly order your columns within the compound index.