Database Tuning (MOSC)

MOSC Banner

Query takes 5 seconds to run .. need to speed it up.

edited Sep 8, 2010 6:12AM in Database Tuning (MOSC) 7 commentsAnswered
Hi .. I have a table of about 20K rows and am performing this query on Oracle 11g Windows 2003 Server. The query I am running is just below and it takes about 5 seconds per query and i am having to run it on average about 1500 times per 20K rows. A long time. Can it be sped 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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center