如何在 SQL Server 中创建物化视图?

2021-12-02 00:00:00 sql-server database-design indexed-views

我要设计一个 DW，我听说了物化视图.实际上我想创建一个视图，它应该在基表更改时自动更新.任何人都可以用查询示例来解释..

I am going to design a DW and I heard about materialized views. Actually I want to create a view and it should update automatically when base tables are changed. Can anyone explain with an query example..

推荐答案

它们在 SQL Server 中被称为索引视图 - 阅读这些白皮书了解更多背景信息:

They're called indexed views in SQL Server - read these white papers for more background:

  • 创建索引视图
  • 使用 SQL Server 2008 索引视图提高性能

基本上，您需要做的就是:

Basically, all you need to do is:

  • 创建常规视图
  • 在该视图上创建聚集索引

大功告成！

棘手的部分是:视图必须满足许多约束和限制——白皮书中概述了这些.如果你这样做，那就是全部了.视图自动更新，无需维护.

The tricky part is: the view has to satisfy quite a number of constraints and limitations - those are outlined in the white paper. If you do this, that's all there is. The view is being updated automatically, no maintenance needed.

其他资源:

  • 在 SQL Server 中创建和优化视图
  • SQL Server 索引视图

相关文章