From the past experience using the schema bound and indexed view in a query with
(noexpand) hint usually dramatically improves performance if the view is designed well.
Apparently using the indexed views is not implicit, as it requires a table hint.
But can there be any scenarios where supplying
(noexpand) hint may be undesirable while the view remains schema bound and indexed?
In other words, should schema bound indexed views be "not expanded" implicitly at all times instead of a developer having to remember to supply the hint to turn off view expansion?