FORCESEEK Archives - SQLServerGeeks

FORCESEEK hint in SQL Server 2008 – Part II -working with Parameter Sniffing

May 17, 2011December 18, 2014 - by Amit Bansal - 4 Comments.

Hi Friends, In Part 1, I introduced the FORCESEEK hint in SQL server 2008 that can force the query optimizer to perform a seek instead of a scan on an index. …