SQL Server 2008 R2中的视图索​​引 [英] Index on view in the SQL server 2008 R2

问题描述

我们可以在一个与两个不同数据库中的表格对话的视图上创建索引吗？



谢谢，

Surendra

解决方案

http://msdn.microsoft.com/en-us/library/ms191432.aspx [ ^ ]



SQL Server索引视图 - 加速您的选择查询：第1部分 [ ^ ]



sql-server-indexed-view-always-use-index-on-index / [ ^ ]

你也应该检查一下：



http://blog.sqlauthority.com/2010/09/06/sql-server -index-on-view-not-used-often-limitation-of-view-3 / [ ^ ]

Hi,

Can we create Index on a view which is talking to the tables from two different database?

Thanks,
Surendra

解决方案

http://msdn.microsoft.com/en-us/library/ms191432.aspx[^]

SQL Server Indexed Views - Speed Up Your Select Queries: Part 1[^]

sql-server-indexed-view-always-use-index-on-index/[^]

you should also check this:

http://blog.sqlauthority.com/2010/09/06/sql-server-index-created-on-view-not-used-often-limitation-of-the-view-3/[^]

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