Indexed Views vs. Regular Views
Learn how indexed views differ from regular views.
Bill McEvoy
August 27, 2008
1 Min Read
![Indexed Views vs. Regular Views Indexed Views vs. Regular Views](https://eu-images.contentstack.com/v3/assets/blt07f68461ccd75245/bltd2fc13615b1322fa/66277801b2103c860eb61d86/code-sql-database-595x335_0_0.jpg?width=1280&auto=webp&quality=95&format=jpg&disable=upscale)
SQL Server 2005 and SQL Server 2000 support indexed views, which are also known as materialized views. When a unique clustered index is added to a view, the resulting indexed view materializes and persists the data in physical storage. Unlike regular views, which are virtual and take up only temporary storage space at runtime, indexed views are permanent and require permanent disk storage.
You can read more about indexed views in the SQL Server 2005 Books Online (BOL) documentation at www.microsoft.com/technet/prodtechnol/sql/2005/impprfiv.mspx.
Main article: T-SQL 101: Views
About the Author
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
You May Also Like