This discussion is archived
14 Replies Latest reply: Aug 29, 2013 7:07 AM by Jeff Smith SQLDev PM RSS

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

632d46a2-7d7c-4e63-8e95-73ac0e592cb6 Newbie
Currently Being Moderated

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...^^

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points