如何在SQL Server中创建物化视图？ [英] How to create materialized views in SQL Server?

问题描述

我要设计一个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索引视图提高性能

• Creating an Indexed View
• Improving Performance with SQL Server 2008 Indexed Views

基本上，您需要做的只是：

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索引视图

• Creating and Optimizing Views in SQL Server
• SQL Server Indexed Views

这篇关于如何在SQL Server中创建物化视图？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！