19Jan/09
FORCESEEK Hint – SQL Server 2008
New article posted on "Forceseek Hint" in SQL Server 2008. Check it out from the link below.
Forceseek hint is a new addition to SQL Server 2008. It forces the query optimizer to use an Index seek instead of Index scan. Forceseek applies to both clustered and nonclustered index seek operations. It can be specified for any table or view in the FROM clause of a SELECT statement and in the FROM clause of an UPDATE or DELETE statement.