Unanswered: Help on Clustered index scan or index scan VS Clustered index seek or index seek
I wish to know more about these index scan and index seek. I am doing an audit in a data base and stored procedure created by some one. Most of the stored procedure for selecting records, the devleopers written with COALESCE in where clause to make more option like NULL values.
When I do query excution plan for the queires with COALESCE it is doing clustered index scan or index scan. If I remove COALESCE option, the query plan I can see clustered index seek or index seek.
I hope clustered index seek or index seek is good way of doing query.
All I need is more explanation for clustered index scan or index scan VS
clustered index seek or index seek. Does any one can suggest the articles or white papers having this. Because the microsoft document is not explaining much or i may not looking in proper document.
Thanks in advance