开发者

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

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜