Hi.I have this problem in FB 2.5 with x as (SELECT * FROM tbl_x1 JOIN tbl_fk1 ON cond_1 WHERE cond_w1UNIONSELECT * FROM tbl_x1 JOIN tbl_fk1 ON cond_2 WHERE cond_w2) select tbl_2.pk_id from tbl_2 where tbl_2.pk_id in (select list(x.tbl2_pk_id) from x
The plan in the X table is OK, but in tbl_2 is natural How can I specify the right plan? Thank