Materialized view (MV) and table

最新推荐文章于 2025-03-25 13:48:44 发布

转载最新推荐文章于 2025-03-25 13:48:44 发布 · 88 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/u/2275100/blog/853935

本文探讨了Materialized View (MV) 和传统表之间的区别。MV专为断开连接的计算而设计，用户对MV所做的更改不会立即对其他用户可见，直到更新数据库服务器。此外，当MV基于多个表并使用复杂查询构建时，使用MV可以显著提高性能。

2019独角兽企业重金招聘Python工程师标准>>>

Materialized view (MV) is for disconnected computing, the difference between table and MV is table you can do DML operations which will be seen by other users whereas the changes you do to MV will not be available to others until you update your database server.

MV has another advantage when you build MV based on multiple tables using complex queries, the users when using MV the performance increases drastically.

转载于:https://my.oschina.net/u/2275100/blog/853935