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...
This post has been moved to http://blog.cumps.be/search-file-contents/