Reputation: 33
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.
Upvotes: 2
Views: 58
Reputation: 452988
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.
Upvotes: 2