Though I'd point to an excellent article on Indexed Views. For those who don't know what these are, well, if you have a fairly complex database schema, you can gain a great deal of performance benefits by aggregating the output of common queries into indexed views. Unlike normal views, these are authomatically updated when the underlying data changes (normal views are pretty much just running another query when you call them). They're best suited when you perform frequent queries on relatively static underlying data (kind of a database level cache)...