Indexed Views in SQL Server
Click here to Subscribe to IT PORT Channel : / @itport28
A Clustered index is the only type of SQL Server index that contains data; the Clustered index on a view contains all the data that makes up the view definition. As soon as you create this clustered index, the View is materialized, meaning SQL server allocates storage space for it.