question

An indexed view is also known as a materialised view, as the clustered index that you create on the view contains all the data in that view, so the view is materialized, or built, unlike non-indexed views , which are simply stored queries. The index is stored in the database in the same way as your other tables and indexes - you can specify the filegroup/file etc. See [MSDN - Create Indexed Views][1] [1]: http://msdn.microsoft.com/en-us/library/ms191432.aspx