-
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?
~KD.DBA~
-
Use 10053 trace event.
Tamil
-
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.
~KD.DBA~
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|