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

mike...

-----Original Message-----
From: Svein Erling Tysvar
[mailto:svein.erling.tysvaer@...]
Sent: Wednesday, August 15, 2001 8:26 AM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Importing Records

>if any body can think of a way to create a better index for this type of
>query, please let me know

Mike,

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

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/