Freeze indexed view

• Roust_m

  SSCoach

  Points: 17410

  More actions

  October 14, 2009 at 1:13 am

  #212108

  Hi,

  Just wondering if there is any way to temporary freeze an indexed view from the updates happening on the underlying tables. What I want to achieve is to be able to update/insert into the tables without causing page splits on the indexed view indexes and have the view available for queries, then when the data load is finished re-create the indexes on the view.

  Thanks.

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  October 14, 2009 at 1:19 am

  #1065514

  No, you could copy the view to another object but not freeze it..

  CEWII