THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Indexed View » Deadlocks   (RSS)
  • 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. ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on June 2, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement