snippetMinor
How do we create spatial index on views if it is possible?
Viewed 0 times
createviewspossiblehowindexspatial
Problem
Is it possible to create spatial index on sql server 2008? If yes how do we create it on table with schemabinding?
Solution
Unfortunately I don't believe you can. XML and Spatial Indexes can only be created tables. Not views.
Edit:
Here's some proof for you straight from BOL: Restrictions on Spatial Indexes
Spatial Indexes cannot be specified on indexed views.
Edit:
Here's some proof for you straight from BOL: Restrictions on Spatial Indexes
Spatial Indexes cannot be specified on indexed views.
Context
StackExchange Database Administrators Q#15223, answer score: 7
Revisions (0)
No revisions yet.