>When I tried a compound index, it didn't use the index, read whole file
>to do the query..

That just does not make sense. It should at least use the index for the
first field when using BETWEEN (Latitude if you used the same order as I
wrote). Maybe it got confused by multiple indexes available? If you have
CREATE INDEX PLACE ON EXPERIAN (LATITUDE, LONGITUDE)
you should also
DROP INDEX LATITUDE (since this already is covered by the above index)

And do try to avoid using more than one index for your query...

Set