Query takes 5 seconds to run .. need to speed it up.
Thanks
Jeff
select Name, latitude, longitude from meter_points where abs(latitude - <Static Latitude>) <= .007 and abs(longitude - <Static Longitude>) <= .012 and iscollector = 0 and customerid = 42;
Here is the table structure :
CREATE TABLE meter_points
(
NAME varchar(100),
Latitude number,
longitude number,
iscollector int,
Customer varchar(30) not null,