当前位置: 动力学知识库 > 问答 > 编程问答 >

tsql - Indexed View in SQL Server

问题描述:

Can I create an index on a view which references synonyms which point to a linked server? Since the view isn't based on local tables I wasn't sure if it was possible.

网友答案:

Nope.

You can't schema bind a view that references external objects and this is only one prerequisite for indexing it.

An indexed view can only reference objects within the database.

分享给朋友:
您可能感兴趣的文章:
随机阅读: