Hugo Kornelis (2/13/2012)
Toreador (2/13/2012)
On Enterprise edition the results are the same - the view index is used.On both this and Developer edition I get a warning for each statement
"Warning: Index hints supplied for view 'dbo.v1' will be ignored."
*lol* I was so wrapped up in checking the execution plan that I completely forgot to check out the messages pane. Yes, I get this warning as well (Developer Edition).
I'm still interested in the results of running this code in non-Enterprise and non-Developer editions, but given this warning message, I estimate a 95% probability that the index hints will be ignored on those editions as well.
Hugo
I ran your code under R2 DataCenter, up to date, and got 'Warning: Index hints supplied for view 'dbo.v1' will be ignored.' 5 times.