I have an indexed view that uses two tables. i have 10 non-clustered indexes on this view to support search functionality for 10 columns. The tables are high traffic oltp tables. For my query i get 500,000 rows after join and where conditions. I see good performance gains on this one. However i have below qtn.
whenever there is an insert/update into the underlying tables which happens often will the indexes be created for each insert/update? if yes,
a) will it be partial update or full update ?
b) Will the index be updated during insertion/update into underlying tables or while selecting from view the next time after insert/update?