Paul White expands upon NOEXPAND:
There is another consequence of not using the
NOEXPAND
hint, which I mentioned in passing a couple of years ago in my article, Optimizer Limitations with Filtered Indexes:The
NOEXPAND
hints are needed even in Enterprise Edition to ensure the uniqueness guarantee provided by the view indexes is used by the optimizer.
If you use indexed views in your environment, read this article.