colin Leversuch-Roberts (2/17/2009)
whether you can pass one index hint i have no idea - never tried that.
You can't. Plan guides are limited to the hints that appear in the OPTION clause, which index hints do not.
The only way to force an index is to use the WITH PLAN hint, which is a little extreme.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass