lec_sas wrote:

> I am doing some volume testing and I ran across the following
> issue. The query I have pasted below runs against two tables. Bern1
> having 3730 records, Bern2 having 2987.

the next thing that would help are the two generated plans and a
brief description of the indexes available and their selectivity.
You might check the archives of this list for a message from Arno
Brinkmann describing the need to distribute OR conditions in some
cases on Firebird prior to V2.0

Regards,


Ann