Using SQL Server FORCESEEK table hint to solve PARAMETER SNIFFING issues

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">