14 Replies Latest reply: Aug 29, 2013 9:07 AM by Jeff Smith Sqldev Pm-Oracle RSS

    How to get the plan before running the query In SQL DEVELOPER?

    632d46a2-7d7c-4e63-8e95-73ac0e592cb6

      HI...

      For tuning a long query in anothen tool(TOAD OR GOLDEN...), I can get the explain plan before running the query

      But I can not get the explain plan before complete the query In SQL DEVELOPER.

      I want to get the plan before running the query.

      How to get the plan before running the query In SQL DEVELOPER?

       

      Right click Explain plan or F10, get the plan after complete running the long query.

      It takes time to get the plan long time.  short time for short query, of cource.

       

      I've used v3 and v4.  They are same.   long time to get a plan for the long query.

       

      Thans in advance...^^