Hi All,
I am production DBA and today i was asked by one of the developers if I can come up with an equivalent way of materialized view in SQL Server. I didnt know much about materialized views in the first place and I asked why, I was told they need a way to store/cache calculated aggregate values in views. They dont want to run expensive query to the table directly. I suggest that we build a data warehouse so that users can directly query the info they want from the DW. But they dont like the idea since the data in the base table itself is loaded every time from many places. I am looking at indexed views right now but they seem complicated and hard to maintain. Also aggregate values are going to be stored in the views.
I guess my question is how do you do it easily if you are assigned with the same task?
FYI: My enviroment is SQL 2005 on windows 2003.
Thank you,