开发者

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

开发者 https://www.devze.com 2023-02-28 18:32 出处:网络
I have a view which already has SchemaBinding applied AND it has a UNIQUE CLUSTERED index. N开发者_Python百科ow, I\'m trying to add a second index, which is a SPATIAL index ... and I get the following

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

N开发者_Python百科ow, I'm trying to add a second index, which is a SPATIAL index ... and I get the following error message:-

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

And here's the a picture of the schema:

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


FFS - I found my answer.

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.

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

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

0

精彩评论

暂无评论...
验证码 换一张
取 消