Helen, Artur,

Thanks for the responses. I did as bth you suggested - dropped all
my various indices, wathed the plan (read up a bit on it as well!!).
I guess I just got hung-up on the firebird bug, which it turns out
was not the case.

Alwasy interesting that dropping indexes can speed something up!!

Thanks again for the pointers

Stewart

--- In ib-support@y..., "Artur Anjos" <arsoft@n...> wrote:
>
> Hi Stewart,
>
> I believe you have a problem with the optimiser. Maybe your query
will be
> must faster if you remove all of your indexes from the table, and
use an
> index just in ZipCode. Of course this method could speed up this
specific
> query, and put another queries slower.