I have a very small 180K rows table with clustered index on
startEffectiveDate,EndEffectiveDate. Still when I run select statement
with this where clause it takes 49 seconds. Which is way too much and
not acceptable.
Please help?

Thanks

Kanwar

MS Sql Server LazyDBA home page