Improving Performance with SQL Server 2000 Indexed Views

MSDN Article on Indexed Views. Indexed View represents a new feature launched with the SQL Server 2000 and it is defined as: “Indexed views can significantly improve the performance of an application where queries frequently perform certain joins or aggregations. An indexed view allows indexes to be created on views, where the result set of the view is stored and indexed in the database”. The article is very well written and should be considered for performance SQL code.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/indexedviews1.asp