Queries have different plan with UNION
I have 2 query like this:
select * from emp where emp_no=2;
select * from emp where emp_no=3;
when i look at their execution plan seperately, it works fine and no problem but,
when i do this;
select * from emp where emp_no=2
union
select * from emp where emp_no=3;
i see different plan for both.
Is there a way to make use their own plan independently in union statement?