Hi Stephen. Don't forget to include your PLAN details where possible
when asking about index oddities. This shows others exactly what
indexes the engine is using and may get you responses even faster
than this time.

Regards,
Andrew Ferguson
-- The future now, if not sooner.

--- In ib-support@y..., "Stevio" <redeagle@f...> wrote:
> You guys all win a prize :-) !!!
>
> I removed the index and the query now takes less than 1 second.
>
> 4.51pm - post message about a slow query
> 5.10pm - query is now fast
>
> The internet rocks (says an internet user of 8 years now :-)
>
> Stephen
>
> > Yeah the field is indexed. So removing it would help?
> >
> > I'll try that.
> > Thanks,
> > Stephen