Subject | What fields to index on... |
---|---|
Author | Mike Grover |
Post date | 2001-08-13T19:20:01Z |
I have to fields, LATITUDE 9 char and LONGITUDE 9 char.
I want to run a query like this
SELECT * FROM MYTABLE WHERE LATITUDE BETWEEN '036995676' AND '036996621' AND LONGITUDE BETWEEN '098337558' AND '098337689'
what index type would yield a faster query?
CREATE INDEX LATITUDE ON MYTABLE (LATITUDE);
CREATE INDEX LONGITUDE ON MYTABLE (LONGITUDE);
or
CREATE INDEX LATLONG ON MYTABLE (LATITUDE,LONGITUDE);
thaks, mike
I want to run a query like this
SELECT * FROM MYTABLE WHERE LATITUDE BETWEEN '036995676' AND '036996621' AND LONGITUDE BETWEEN '098337558' AND '098337689'
what index type would yield a faster query?
CREATE INDEX LATITUDE ON MYTABLE (LATITUDE);
CREATE INDEX LONGITUDE ON MYTABLE (LONGITUDE);
or
CREATE INDEX LATLONG ON MYTABLE (LATITUDE,LONGITUDE);
thaks, mike