这张图是从一位牛人的博客贴过来的,原帖地址如下:http://iablog.sybase.com/paulley/2009/05/materialized-view-terminology/
DBMS | Terminology | When | How | Who |
---|---|---|---|---|
MS SQL Server | Indexed Views | Immediate | Incremental | System |
IBM DB2 | Materialized Query Tables | Immediate and Deferred | Incremental or Rebuild | System or User |
Oracle | Materialized Views | Deferred | Incremental or Rebuild | System or User |
SQL Anywhere | Materialized Views | Immediate and Deferred | Incremental or Rebuild | System or User |
此图清晰的表达了物化视图在各主流数据库中的叫法、什么时候做、怎么做、谁来做的问题,so cool!了解详细介绍,访问原帖地址。
Glossary:Materialized View 物化视图
Incremental 增量
Defered 延迟