This post originated from an RSS feed registered with .NET Buzz by David Cumps. Original Post: Efficient Compound Index Usage Feed Title: David Cumps Feed URL: http://weblogs.asp.net/cumpsd/rss?containerid=12 Feed Description: A Student .Net Blog :p Latest .NET Buzz Posts Latest .NET Buzz Posts by David Cumps Latest Posts From David Cumps

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/