HiveBrain v1.2.0
Get Started
← Back to all entries
snippetMinor

How do we create spatial index on views if it is possible?

Submitted by: @import:stackexchange-dba··
0
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.

Context

StackExchange Database Administrators Q#15223, answer score: 7

Revisions (0)

No revisions yet.