Skip to content

SQL-Articles

On Premise and Cloud Database Knowledge Base

Tag: forceseek

FORCESEEK Hint – SQL Server 2008

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… Continue reading FORCESEEK Hint – SQL Server 2008

Published January 18, 2009
Categorized as DBA Tagged forceseek, performance

Recent Posts

  • CSSUG February 2020 Meet
  • CSSUG January 2020 Meet
  • CSSUG November 2019 Meet
  • CSSUG October 2019 Meet
  • Dropping a Subscriber from AG Publisher
SQL-Articles
Proudly powered by WordPress.