what was the fix?

thanks

So I used the query below but it still does a scan instead of seek.

select count(*) from tpa_arch.dbo.taxdata with (index(pk_taxdata)) where procperiod=200409

Thanks for the reply. procperiod is the first field. I think it is the optimizer also but don't understand why. The query returns the same result but takes about 2...

I have a related issue that hopefully I can get some help with. On a sql 7 server my query uses a clustered index seek and the same database on...