- You have an instance of SQL Server 2012 on a computer that has more than one processor and you run a parallel query against a table that has a large amount of spatial data.
- You may notice that the query optimizer does not use the spatial index
We had a similar issue fixed in SQL Server 2008 R2 http://support.microsoft.com/kb/2570501
We can use the workaround mentioned in above KB:
To work around this issue, use one of the following methods:
- Use the spatial index hint option in the query.
- Disable the parallel execution plan option for the query.
SQL BU Defect Tracking 20179508 - Spatial index not used on multiproc machine unless MAXDOP set downward