Subject What fields to index on...
Author Mike Grover
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