Question

Bob Hovious on Sun, 28 Mar 2010 17:52:05


My understanding is that a spatial index is only used for the primary filter.    That is, it speeds up identification of the candidate list that goes through the secondary (calculation) step.     Does that mean that calculations are even done on points that lie within grid squares that are completely covered by a shape?

Sponsored



Replies

Bob Beauchemin on Sun, 28 Mar 2010 18:33:13


No, the calculations are not done in that case. In the spatial index
analysis procs' output, this is referred to as the "internal filter". See
http://www.sqlskills.com/BLOGS/BOBB/post/Spatial-Index-Diagnostic-Procs-Filters.aspx
(its part of a blog series) for more information.

Cheers,
Bob Beauchemin
SQLskills

"Bob Hovious" wrote in message news:033d36d7-14d7-4863-bf87-dd516ff144d6...
My understanding is that a spatial index is only used for the primary
filter. That is, it speeds up identification of the candidate list that
goes through the secondary (calculation) step. Does that mean that
calculations are even done on points that lie within grid squares that are
completely covered by a shape?

Bob Hovious on Sun, 28 Mar 2010 18:42:00


I am SO happy to hear that.   Thanks, Bob!