I have recently written many articles on the limitation of the views. In this article, I have tried to sum up all the keywords which are not allowed in the indexed view. If any of the following keyword is used in the View, Index is not possible to create on the same.
Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more…
I think this list can be used as quick reference for anybody who wants to create a view and index it to get best out of the views.
After looking at the long list which contains Self Join, TOP, UNION, OUTER JOIN and many other useful keywords, one has to wonder how limited the usage of the query is in the view. One cannot utilize the full potential of the views.
Views have many limitations and the list is limitless! Please comment with your ideas below.