1 - ORDER BY clause does not work in View.

2 - 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 the first.

3 - Index created on view not used often.

4 - 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.

5 - One of the most prominent limitations of the View is that it does not support COUNT (*); however, it can support COUNT_BIG (*).