3 ms·
Implementing efficient updates of materialized views is difficult. They have to support recursive queries, aggregation, and probably even recursive views that t
by jkbyc 13y ago
Implementing efficient updates of materialized views is difficult. They have to support recursive queries, aggregation, and probably even recursive views that they list as new in "Additional Features."
Algorithms for updates of materialized views exist since at least 20 years but maybe they don't cover all these cases efficiently.
- daigoba66 13y agoThe implementation used by MSSQL is pretty restrictive in terms of what kind of query can be indexed. But it works rather well.