Materialized Query Table in SQL Server 2005
- by Azho KG
In DB2 there is a support for Materialized Query Table (MQT). Basicly you write a query and create a MQT. But the difference from View is that the query is pre-executed and resulting data is stored in MQT and there are some options when to refresh/syncronize the MQT with base tables.
I want same functionality in SQL Server. Is there a way to achieve same result?
I've tables with millions of rows, and I want to show summary (like total # of members, total expense and etc) in dashboard. So I don't want to count every time user gets to dashboard, instead I want to store them in table and I want that table to be refresh each night.
Any kind of hints, answers,suggestions and ideas are welcome.
Thanks.