This might be a weird question...is there any way to disable a
particular index without dropping it?
There are a few queries I run where I'd like to test out the effects
of having (and not having) different indexes on particular query plans
and performance. I'd really prefer not to have to drop and ultimately
recreate a particular index, as some of the data sets are quite large.
So, is there any way to do this, or at least mimic this sort of behavior?
Peter