SQL Server 索引视图与 Oracle 物化视图 [英] SQL Server Indexed Views vs Oracle Materialized View

问题描述

我知道物化视图并且我正在使用它.我从未使用过索引视图，但我会使用.它们之间有什么区别?

I know materialized view and I'm using it. I have never used indexed views but I will. What are the differences between them ?

推荐答案

SQL Server 的索引视图始终保持最新.在 SQL Server 中，如果修改了视图的基表，则视图的索引也会在同一个原子事务中保持最新.

SQL Server’s indexed views are always kept up to date. In SQL Server, if a view’s base tables are modified, then the view’s indexes are also kept up to date in the same atomic transaction.

Oracle 提供了类似的东西，称为物化视图.如果 Oracle 的物化视图是在没有 **REFRESH FAST ON COMMIT** 选项的情况下创建的，那么物化视图在其基表被修改时不会被修改.所以这是一个主要区别.虽然 SQL Server 的索引视图始终保持最新，但 Oracle 的物化视图可以是静态的.

Oracle provides something similar called a materialized view. If Oracle’s materialized views are created without the **REFRESH FAST ON COMMIT** option, then the materialized view is not modified when its base tables are. So that’s one major difference. While SQL Server’s indexed views are always kept current, Oracle’s materialized views can be static.

这篇关于SQL Server 索引视图与 Oracle 物化视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！