When is an index created on view actually used? After showing it is often ignored, I demonstrate a condition where SQL Server uses it, including NOEXPAND.
SQL SERVER – Index Created on View not Used Often – Limitation of the View 12
At my Hyderabad seminar someone asked: will an Index Created on a view be used when you query the view? Not always. Limitation 12 of views explained.
Schema-Bound Views: Protect Referenced Columns
Schema-bound views protect referenced columns during table changes. Compare blocked DDL with compatible additions, and check how an ordinary view can retain stale metadata until it is refreshed.
SQL SERVER – List of all the Views from Database
Hundreds of Views and no idea which are indexed? A quick query on sys.views lists every view with its schema and whether it is indexed or indexable.
SQL SERVER – Indexed View always Use Index on Table
A table can have only one clustered index, but what about an indexed view built on the whole table? My T-SQL Tuesday post tests which index SQL Server uses.
Indexed View Quiz: The Table and Clustered Index Confusion
An indexed view and its base table can each own a clustered index because they are separate objects. Inspect both owners in a SQL example and see why a view index does not give its base table a second clustered index.
SQL SERVER – View Over the View Not Possible with Index View – Limitations of the View 11
Why can’t you create a view over the view and index it? An index view cannot reference another view. Limitation of the view 11 shows an example.