使用 openquery 创建索引
如何使用 openquery 语法在远程 SQL Server 数据库中存在的表上创建索引?
How do I create an index on a table that exist in a remote SQL Server database using the openquery syntax?
推荐答案
你不能站在你这边.索引必须仅添加到本地对象.您也不能使用索引视图.
You can't on your side. The index must be added to a local object only. You can't use an indexed view either.
您可以要求对方为您在他们的表中添加索引...
You can ask the other party to add an index for you to their table...
扩展约翰的答案......你可以尝试:
Expanding John's answer... You could try:
SELECT * FROM OPENQUERY(LinkedServer, 'CREATE INDEX etc;SELECT 0 AS foobar')
相关文章