Materialized View/Index View

A View created with a unique clustered index is known as an Indexed View or Materialized View.


Unlike views, an indexed view exists on the disk like a table in which the clustered index is created. Once a Clustered Index is created you may create non-clustered indexes on the view.