If I have a filtered index, and if I use data beyond that range, what kind of performance hit would be incurred?
+2
A:
It will be the same as if the index did not exist. The exact impact on performance depends on your specific data.
mtreit
2010-10-16 02:12:27