Subject | Re: [ib-support] Importing Records |
---|---|
Author | Svein Erling Tysvær |
Post date | 2001-08-15T13:25:37Z |
>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!
HTH,
Set