The view definition is stored by SQL Server so that it can be used as a virtual table to ... Indexed views. In SQL Server 2000 and 2005, you have the ability to add indexes to views.