See performance gains by using indexed ... In fact, a view really doesn’t do anything until you query it. In SQL Server 2000 and 2005, you have the ability to add indexes to views.