Limitations Of View & Catalog View

Limitations Of View & Catalog View

ORDER BY clause does not work in View.
Regular queries or Stored Procedures give us flexibility when we need another column; we can add a column to regular queries right away. If we want to do the same with Views, then we will have to modify them first.
(Read more here)
--Index created on view not used often.
--Once the view is created and if the basic table has any column added or removed, it is not usually reflected in the view till it is refreshed.
--One of the most prominent limitations of the View it is that it does not support COUNT (*); however, it can support COUNT_BIG (*).
--UNION Operation is now allowed in Indexed View.
--We cannot create an Index on a nested View situation means we cannot create index on a view which is built from another view.
--SELF JOIN Not Allowed in Indexed View.
--Outer Join Not Allowed in Indexed Views.
--Cross Database Queries Not Allowed in Indexed View