Archive for tag: noexpand

A Hint on Using Indexed Views For Read Performance

13 April, 2010 (13:13) | SQL, T-SQL | By: Mark V

Some time ago, I was on a project in which we implemented a report model. The data was located in several different databases, none of which were very conducive to reporting. The consequence was that the views upon which we based our entities for the model required lots of joins and performed poorly. We decided […]