Some of the limitations with Indexed views are:

• The UNION operation is not allowed in an indexed view.
• We cannot create an Index on a nested view scenario which means we cannot create index on a view built from another view.

Continue reading Sql Interview question: What are the limitations of indexed views? →