I have a Geo table with geometry column storing point data
I need to find all points within a given distance in meters of a Longitude, Latitude
Do I create a geography column from the geometry column or the Longitude, Latitude stored in the table
Do the conversion on the fly within the query
Could someone suggest how to perform both options and there pro & cons?