SQL Server Performance

Using SQL Server FORCESEEK table hint to solve PARAMETER SNIFFING issues

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Jan 9, 2009.

  1. Anonymous New Member

    Let us talk about few HINTS that can help to optimize the performance of a query, but bear in mind when using an INDEX hint it forces the query optimizer to use only the specified indexes to access the data in the referenced table or view in the query. In such aspects FORCESEEK hint is one of them that forces the optimizer to use only an index seek operation to access the data in the referenced table or view. As you may aware that this hint in SQL server 2008 that can force the query optimizer to...(<a href="http://sqlserver-qa.net/blogs/sql2008/archive/2009/01/09/4894.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=4894" width="1" height="1">

Share This Page