Indexed View

http://www.sqlservercentral.com/articles/Performance+Tuning/71482/
http://www.mssqltips.com/sqlservertip/1610/sql-server-schema-binding-and-indexed-views/