Archives for: "July 2011"

Filtered Index with WHERE col IN (...) clause
Jul 14th
I was asked if it is possible to create an filtered index with a WHERE col IN (…) clause and then use WHERE col = n with n being one of the values of the (…) list
So let’s create a small sample
[codespan]create table idx
(
ID int NOT NUL… more »