DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Explain Plan

  1. 09-08-2004, 02:56 AM #1
    preetham
    preetham is offline Junior Member
    Join Date
    Sep 2004
    Posts
    5

    Unhappy Explain Plan

    Hi
    Will Explain plan take same amount of time to run,if it is running for a query where this query is taking 94 min to execute.

    please give me details about it.

    regards
    preetham
    Reply With Quote Reply With Quote
  2. 09-08-2004, 04:01 AM #2
    Srinivas_Sharma
    Srinivas_Sharma is offline Member
    Join Date
    Jan 2003
    Location
    Hull, UK
    Posts
    220
    Hi

    U can use explain plan just to generate the path which the optimizer will take if u run the query.

    So u r not actually running the query but determining the path.


    Srini
    Reply With Quote Reply With Quote
  3. 09-13-2004, 02:08 AM #3
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    In sqlplus u can do

    set autotrace trace only

    and tryu running the query to get just the query plan minus the results

    regards
    Hrishy
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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