Explain Plan(Transformed Query)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Explain Plan(Transformed Query)

  1. #1
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78

    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~

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Use 10053 trace event.

    Tamil

  3. #3
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78

    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~

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    heard of google?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width