SathishK (2/10/2012)
http://msdn.microsoft.com/en-us/library/ms181151.aspx%5B/quote%5D
Using NOEXPAND means that the optimizer may not use any index on the underlying base table(s). The only freedom the optimizer has is to choose which of the indexes on the view to use. And I have never seen a real-world case where there was more than a single index on a view.