Indexed views. In SQL Server 2000 and 2005, you have the ability to add indexes to views. But, if a view is just a stored query definition in the database with no data of its own until it is run, ...