>I have figured out that I need to index on lat and long seperately.

Hmm, sorry for misleading you, Mike. I guess my experience with one index
being much faster than two is due to me using very restrictive select
criteria. If the first criteria reduce the number of returned rows to only
a very small subset of the table - I still say you don't want to use an
additional index for the second criteria (typically, I use one index for
our national PIN code and a person doesn't have that many records in our
cancer registry). But I've learnt from the last two messages that if both
criteria return a large number of rows, then more than one index can be
benefitial.

Good to see you worked it out despite my advice,
Set