dynamicsusers: What is the cost of maintaining an indexed view?

[Blog bot]

In previous versions, Microsoft Dynamics NAV maintains SIFT totals in SIFT tables. So updating the main table is done in one query. Updating the related SIFT tables is done by seperate queries run from triggers on the SQL tables. This makes it difficult to idenitfy the real cost of updating the table with a SQL Profiler trace, since you need to take several queries into account to get the real cost. From NAV version 5 SP1, the SIFT tables are replaced with Indexed Views which makes it simpler to...(read more)

Подробнее... http://dynamicsuser.net/blogs/navsustatine...dexed-view.aspx