years ago I had already wanted to apply indexed views for a certain query tuning problem, but read that they are only supported in SqlServer Enterprise Edition. I came back to that topic recently, and again all the official documentation I found confirms
that assumption (e.g.
I gave it a try anyway, and could easily create indexed views on Standard Edition. I checked the execution plans, and the view's indizes were applied. The only small restriction I encountered was, that I had to supply a "with (noexpand)" query hint in the
from clause. It even works on SqlServer 2000 Standard Edition.
This is such a valuable feature, probably seldomly applied, because articles and postings everywhere imply that Enterprise Edition is a requirement. I suppose it would be a good idea to correct Microsoft's documentation on that topic. Thank you!
Kind regards, Arno
View Complete Post