Efficient Compound Index Usage

Today I was made aware by Filip, a colleague of mine, about the importance of columns used in a where clause with a compound index. I decided to investigate this a bit more in detail, with proper profiling and comparisons on a large data set.

Read more at http://blog.cumps.be/efficient-compound-index-usage/