|Subject||Re: [ib-support] Importing Records|
|Author||Svein Erling Tysvær|
>When I tried a compound index, it didn't use the index, read whole fileThat just does not make sense. It should at least use the index for the
>to do the query..
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...