>>I think I pointed that out
Re: Getting from distance for geography coordinates Thread #
1529492 Message #
1529530>
>Yes, I have it much simpler now.
In all honesty - you may need that
When I was taking my walk yesterday I figured out the use of the first clause
If you do not have that many records, it does not matter, but with a lot of records there will be a difference in speed
The first clause restricts the set to those that are in a square around you (latitude between .. and ... and longitude between .. and ...)
The second one calculates the radius of the points in the square
Gregory