THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
Be ready to drop your indexed view.
In all-too-many cases an indexed view may solve your short term performance goals but at some later time become counterproductive. So if you choose to use an indexed view, you may need an exit strategy. Let me describe a few common problems with indexed views. Indexed views may increase lock contention. It is very easy to demonstrate. ...
June 2, 2009
Brought to you by