--- In firebird-support@yahoogroups.com, Steve Wiser <steve@...> wrote:

>
> What happens if you remove the "in" and replace it with "or" conditions?
>
> -steve

Same steve.

I think this is what the query optimiser does by default.

The performance was after rebooting also.


PLAN JOIN (S INDEX
(IDXSITE_REGIONID,IDXSITE_REGIONID,IDXSITE_REGIONID,IDXSITE_REGIONID),CO
INDEX (PK_COMPANY),C INDEX (FK1_CLIENT),V INDEX (FK1_VACANCY))

------ Performance info ------
Prepare time = 15ms
Execute time = 8m 21s 625ms