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

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)))))

Adapted Plan
PLAN SORT (SORT (JOIN (A NATURAL(B B INDEX (B_IDX3)) PLAN (B C INDEX (C_IDX8)))))