I have this simple query:
SELECT Count('x') FROM PayeeMaster PM
INNER JOIN PayeeLink PL (nolock) ON PM.PayeeID = PL.PayeeID
that results in an index scan (i tried to attach plan but being blocked)
I have a clustered index for both tables that has all fields, but yet I still get an index scan and not a 'seek'....
There is only this clustered index on this table, no other indexes...And yet it still always gives me a scan not a seek