We are using the below query in one of our stored procedure, it is working fine. But while it is retrieving the data from TempMissingApplied table, index scan is happening even though there is cluster index on table TempMissingApplied on
But i want index seek on this table.
Please suggest me to make index scan as index seek.
FROM dbo.TempMissingAppliedWO tempM
INNER JOIN dbo.Segmentation S ON (tempM.CustID = S.CustID) venkat reddy
View Complete Post