Answer:
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