> >Some brackets missing and no 'PLAN'?
>
> Seems complicated, but maybe one line with
> PLAN(PLAN(PLAN(PLAN(PLAN(PLAN(PLAN( just scrolled off the window?

Possible - but I did scroll up before copying.

> Your second plan seems simpler - and gave me one idea for possible
> improvement:
> LEFT JOIN ROOMSTAT R ON R.TERMINAL = T.ROOM
> Does this give the right result, and is it any faster?

Neat!

Plan is now simpler

PLAN (C3 INDEX (RDB$PRIMARY8))
PLAN (C2 INDEX (RDB$PRIMARY8))
PLAN (C1 INDEX (RDB$PRIMARY8))
PLAN SORT (JOIN ( T INDEX (RDB$PRIMARY8), R INDEX
((RDB$PRIMARY3)))

But if anything it now takes longer.

Using four queries linked by IBO's MasterParamLinks a ten
day report with 800 tickets takes 4 seconds for the preview
to come up.

The previous single query took 65 seconds, this one took 70
seconds to the same point. ( Opening the queries in IB_SQL
takes the same sort of time )

Where should I be asking for an explination into the
differences?

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services