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'
select * from emp where job='CLERK' and empno <> 'E001'
How to find out transformed query, like is there any view?
Use 10053 trace event.
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.
Click Here to Expand Forum to Full Width