Which objects can not be specified "FORCESEEK" table hint from the following list ?

 Posted by PandianS on 9/8/2010 | Category: Sql Server Interview questions | Views: 3942 | Points: 40

Normally we can define hint on Tables, Views, Indexed Views, Table-valued function, CTE, DMV, Table variable, Named Subquery, Openrowset.

But, we can not define FORCESEEK table hint on Table-valued function, Table variable and Openrowset objects/statements.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response