> > What are the engine stats for the query?
> >
> > What PLAN is generated for the query?


> I'm using IB Expert 2009.03.25
>
> The plan is as follow
>
> Plan
> PLAN SORT (SORT (JOIN (A NATURAL(B B INDEX (B_IDX3))
> PLAN (B C INDEX (C_IDX8)))))

What about the stats? (See Performance Analysis tab in IBExpert)


Sean