|Subject||Re: [ib-support] Importing Records|
|Author||Svein Erling Tysvær|
>if any body can think of a way to create a better index for this type ofMike,
>query, please let me know
I'd expect a combined index to be a lot better, i.e.
CREATE INDEX PLACE ON EXPERIAN (LATITUDE, LONGITUDE);
But I must admit that I haven't tried compound indexes on queries like this
where you use BETWEEN for both criteria. Tell us your result!