Query optimizer is doing index scan instead of seek
A(id int, colA, ColB, Col C, Col D, Col E)
I am trying to query it using temp table t with 14 million rows. I am getting an index scan in the plan instead of seek.
T(id, colG, ColH, ColI)
Select count(*) from a inner join t on a.id=t.id
When I look at the plan I see an index scan on table a instead of seek. The stats are updated. I ran a full scan.