Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Performance impact of indexed view in MS SQL Server 2008

Does anyone have experience with using indexed view in MS SQL Server 2008? I am trying to find out how does indexed view affect performance of insert / update statements, that are adding / updating rows in tables, which are being used by the indexed view (assuming the indexed view is a select joining a few tables together). Given that all data that are result of the view's underlying select are indexed, I am guessing that there has to be some 'triggers' behind the scenes that update those indexed data when something is added / changed. However I wasn't able to find any useful information on this matter.

like image 962
Tomas Avatar asked Nov 13 '09 19:11

Tomas


1 Answers

This msdn link is the last word on the subject:
http://msdn.microsoft.com/en-us/library/dd171921.aspx

For your specific question, pay special attention to the "Design Considerations" section, specifically the "Maintenance Cost Considerations" sub-section.

like image 159
Joel Coehoorn Avatar answered Nov 13 '22 02:11

Joel Coehoorn