Are there any weak points with indexed views?

• Saruwatari

  SSC Enthusiast

  Points: 133

  More actions

  July 28, 2008 at 10:24 am

  #130186

  I've created indexed view and try to use it instead of original join. The view uses clustered index. I wonder what weak points are taken place in such a way of retrieving of the data? Are there any restrictions when take deal with high data-changeable table, or when a lot of joins are using in a such indexed view?

  Thanks, Alex.

• GSquared

  SSC Guru

  Points: 260824

  More actions

  July 28, 2008 at 11:20 am

  #849320

  The primary disadvantage to indexed views is that they increase the overhead for insert/update/delete actions on any of the referenced tables.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon