Cautions with Indexed Views

If you’ve been following my blog, you may remember an article I did extolling the virtues of indexed views – http://blogs.msdn.com/microsoftbob/archive/2009/05/13/sql-data-warehousing-tip-2-indexed-views.aspx.  I stand behind that and have found this feature extremely useful.  In fact in my last post the 11 seconds it was taking to perform a few thousand transactions against a 10-million row history…

0