Indexed views, also known as materialized views, can offer significant performance benefits when properly implemented.  SQL Server BoL certainly highlights the benefits in great detail. A co-worker, whom I have the highest regard for his technical / SQL abilities recently asked me to take a look at a query he was running that was behaving [...]