开发者

Performance impact of indexed view in MS SQL Server 2008

开发者 https://www.devze.com 2022-12-11 14:56 出处:网络
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 ro

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 t开发者_运维百科ables 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.


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.


I think it's useful enough to think of the indexed view as being supported by triggers by the system. The performance implications should be similar.

0

精彩评论

暂无评论...
验证码 换一张
取 消