Revenant (2/13/2012)

---

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.