Re: query's performance

2018-02-15 Thread PT
On Thu, 15 Feb 2018 22:43:59 +0100 hmidi slim wrote: > Hi, > I have a table establishment which contains these columns: id, name, > longitude, latitude. > I want to select all the establishments in the table establishment within a > radius from a reference point which is a given establishment. >

query's performance

2018-02-15 Thread hmidi slim
Hi, I have a table establishment which contains these columns: id, name, longitude, latitude. I want to select all the establishments in the table establishment within a radius from a reference point which is a given establishment. For example: I have a given establishment called establishment1 an