BSmith
BSmith

Reputation: 33

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.

Upvotes: 2

Views: 58

Answers (1)

Martin Smith
Martin Smith

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

Related Questions