Create spatial index on all geography column

Apr 28, 2014 at 4:46 PM
Hi,
why there is no spatial index on the geography column ? It would seem logical as speed a lot the geo queries and some software need a spatial index column to work with.
Also an option to use a geometry instead of geography would be useful because some software only handle geometry.

More info here :
http://technet.microsoft.com/en-us/library/bb964712(v=sql.105).aspx
http://technet.microsoft.com/en-us/library/bb964714(v=sql.105).aspx

Thanks.
Apr 28, 2014 at 4:51 PM
Hi,

there should be one, because for that there is the "TaskCreateSpatialIndices" which is creating it. Unfortunately i haven´t maintained the to code for a while, possible i will do soon - hopefully.

greets
Apr 28, 2014 at 5:09 PM
I just saw it, but I had to create the indicies, I don't know why it didn't.

Thanks.
Jun 10, 2016 at 5:10 PM
It's because the TaskCreateSpatialIndices function uses the same index name for both indices. Try changing "idx" to "spidx_tWay" and "spidx_tNode" for the two different tables.