Explain Plan(Transformed Query)
Is it possible to find out the query transformed by optimizer, that generates the best plan.
e.g:- select * from emp
where empno ='E001' or job ='CLERK'
if transformed into
select * from emp where empno='E001'
union all
select * from emp where job='CLERK' and empno <> 'E001'
How to find out transformed query, like is there any view?
Explain Plan (Query Transformation)
Can you provide me some help, how to use it. or provide me some links regarding the usage.
Thanks in advance.