title: SQL Indexed Views : what happens if data has changed
body: <p>I undestand what indexed view are but i wonder what exactly happens when the data in underlaying table(s) has been changed?
  Is entire view cache discarded od just changed rows?</p>
  
  <p>I have very complex query on several tables(+5) which is used for searching hotels availability(+100k records) and IMHO indexed view could improves performance significantly.
  But the data(few rows) are changed frequently(room was sold, free rooms altered in admin atc.) and if the view would be rebuild each time when just one row was changed, would be bottle neck for my app.</p>
  
  <p>Or any ideas how to "cache" very coplex queries?</p>
  
  <p>Thank you.</p>