Luis Cazares - Monday, November 20, 2017 7:46 AM
No, but to use a plan guide you need a hint that gets you the desired behaviour.
Any chance you can change the query that calls the view to not call the view? Should be easier to tune that way.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability