How can I create a Spatial Index on an Indexed View?

Question

I have a view which already has SchemaBinding applied AND it has a UNIQUE CLUSTERED index.

Now, I'm trying to add a second index, which is a SPATIAL index ... and I get the following error message:-

enter image description here

And here's the a picture of the schema:

enter image description here

score 3 · Accepted Answer · edited May 23 '17 at 10:30

3

Spatial Indexes cannot be specified on indexed views.

The error message is incorrect / misleading.

Cheers & Heads up to a previous SO question which is very similar.

Epic Fail again.

enter image description here

edited May 23 '17 at 10:30

Community

answered Apr 27 '11 at 02:20

Pure.Krome

1 Answers1