Summarizing Data in Indexed Views
Another option for storing summarized history data is using indexed views. Indexed views are also known as materialized views because they will compute and store the data. What sets them apart from standard views is that they have unique clustered indexes implemented on them to improve performance of queries run against them. In general, the greatest performance gain will be realized when creating indexed views of data that has been summarized and requires many joins to get the results. If the data you want to query has few aggregations or joins or is frequently updated, indexed views will provide little, if any, performance gain.
Important
Indexed views are only supported in SQL Server Enterprise Edition (2000 ... |
Get Microsoft® SQL Server™ 2005: Applied Techniques Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
