Grant Fritchey (10/22/2013)
You could look at materialized or indexed views. These are actually a separate data store that you have to update to see data changes.
Indexed views do not need to be updated to see data changes. Data changes are automatically applied to the index as if the index was part of the base table.