之前还在郁闷,DB2里面MQT和物化视图有什么区别,后来一搜索,就是一个东西:
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 |
原帖地址:
http://iablog.sybase.com/paulley/2009/05/materialized-view-terminology/