THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Indexed View » query performan... » 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
Privacy Statement