OraFAQ Forum: Client Tools » Explain plan Using toad and SQL Developer

Home » SQL & PL/SQL » Client Tools » Explain plan Using toad and SQL Developer (oracle 10g,)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Explain plan Using toad and SQL Developer [message #411361]

Fri, 03 July 2009 04:26

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

Hi,

How to find explain plan of a query in oracle using TOAD(any) and SQL Developer(any)?

If there any functioanl key to find out please let me know.

Regards,
Balaji

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411363 is a reply to message #411361]

Fri, 03 July 2009 04:33

ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore

Senior Member

Have you set the PLAN_TABLE

Go to View->Options->Oracle->General in TOAD to determine whether you set the plan_table

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411366 is a reply to message #411363]

Fri, 03 July 2009 04:44

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

plan table is all set .please let me know how to view explain plan using function key.

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411367 is a reply to message #411366]

Fri, 03 July 2009 04:46

ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore

Senior Member

how do you do it normally ?? in SQL*PLUS ?? the similar way

explain plan for select * from emp;

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411370 is a reply to message #411361]

Fri, 03 July 2009 05:04

delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City

Senior Member

Alternatively,
SET AUTOTRACE ON, a SQL Plus command.

regards,
Delna

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411372 is a reply to message #411366]

Fri, 03 July 2009 05:15

Frank
Messages: 7877
Registered: March 2000

Senior Member

Ever heard of google.com?
The third hit explains it in Google's overview page..
Being lazy can be a good thing for developers, but this is waay waay too far.

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411373 is a reply to message #411370]

Fri, 03 July 2009 05:15

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

Thanks for your answer.

Is there any other way to find explain plan in TOAD,SQL Developer like using function key somethig like that?

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411374 is a reply to message #411373]

Fri, 03 July 2009 05:16

Frank
Messages: 7877
Registered: March 2000

Senior Member

balaji1482 wrote on Fri, 03 July 2009 12:15

Thanks for your answer.

Is there any other way to find explain plan in TOAD,SQL Developer like using function key somethig like that?

Yes: GOOGLE

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411386 is a reply to message #411372]

Fri, 03 July 2009 05:55

ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore

Senior Member

balaji,

What's your intension understand the EXPLAIN PLAN for your query or doing research on what are the possibilities to get the Explain Plan.

I don't know why are you so keen about the function key, Concentrate on the solution.

By the way google.com is very good if you haven't heard of, I almost gave you the solution but still want to try then please go ahead

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411409 is a reply to message #411386]

Fri, 03 July 2009 07:28

thatjeffsmith
Messages: 18
Registered: July 2009
Location: Raleigh, NC

Junior Member

Getting an execution plan in Toad is pretty straightforward.

In the editor, put your cursor on the statement you want explained. Then, either use the Ambulance button on the toolbar, or use the keyboard shortcut Ctrl+E.

The plan will show in the 'Explain Plan' tab below, next to the data grid.

I'm pretty sure SQL Developer borrowed the same keyboard shortcut Smile

There is a blog on ToadWorld.com customizing the look and feel (and content) of explain plans in Toad, do a Google on 'Customizing Data explain toadworld' to find it.

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411420 is a reply to message #411409]

Fri, 03 July 2009 08:13

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

This is what the answer i was expecting ie the keyboard shortcut (ctrl+E). Earlier sometimes back i was using it and cannot remember now.

I searched in Google for my answer but was not able to find out.

Thanks for your answer.

Regards,
Balaji

[Updated on: Fri, 03 July 2009 08:17]

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411421 is a reply to message #411361]

Fri, 03 July 2009 08:22

ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore

Senior Member

Hey Congrats !!! Finally you did it without wasting time in googling....

Even i did some googling and found a page for you !!!

http://www.mandsconsulting.com/toad-sql-editor-useful-shortcuts

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411460 is a reply to message #411421]

Sat, 04 July 2009 01:45

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

Actually i was in need of prompt answer after spending time in Google for few minutes.It was an urgent task .

anyway thanks for spending your precious time in googling and many thanks to hillbily

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411507 is a reply to message #411460]

Sat, 04 July 2009 08:06

pablolee
Messages: 2077
Registered: May 2007
Location: Scotland

Senior Member

Quote:

It was an urgent task .

How on earth could finding the shortcut key to generate an explain plan in TOAD be considered urgent?

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411530 is a reply to message #411460]

Sat, 04 July 2009 14:12

Littlefoot
Messages: 16947
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

@balaji1482, you know, there's that "Help" thing (available in TOAD too) which gets open once you press the F1 key (which is in many / most applications mapped to "Help").

Then there's the "Search" tab. You are (actually, were) supposed to put "explain plan" in there and press <Enter>. Choose the very first topic which talks about "Explain plan". There's all about the ambulance icon, as well as <Ctrl + E>.

The whole process lasted half a minute (for me), and almost 4 (four) hours for you. One doesn't have to be ./fa/5851/0/

in order to find such information.

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411604 is a reply to message #411530]

Sun, 05 July 2009 23:50

ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore

Senior Member

@Littlefoot,

I don't have TOAD (Currently...According to Michel's suggestion Smile

) and it took me not more than 10 min to search in Google Smile

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #427571 is a reply to message #411361]

Fri, 23 October 2009 05:07

Dont_Be_A_Dork
Messages: 1
Registered: October 2009

Junior Member

Hi Frank and ashoka_bl! You know, this forum could do without your "holier than thou" replies. If you're not here to help then why don't you both piss off.

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #427572 is a reply to message #427571]

Fri, 23 October 2009 05:10

Frank
Messages: 7877
Registered: March 2000

Senior Member

Considering this being your first and only contribution to this forum so far, I would say this is a typical case of the pot calling us black..

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #515044 is a reply to message #427571]

Thu, 07 July 2011 20:26

no_spam77
Messages: 2
Registered: July 2011
Location: Durham NC

Junior Member

I agree and think the original poster showed grace and humility in his/her replies. All to often when I go search for help after working hard for an answer I find these sort mean arrogant time wasting unnecessary replies. Readers please indulge my time waisting off topic comments.

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #515046 is a reply to message #515044]

Thu, 07 July 2011 21:33

wvu1999
Messages: 38
Registered: April 2007

Member

I'm with you. I don't understand the need to belittle people asking for help. If you don't like the question, then leave it alone.

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #515071 is a reply to message #515046]

Fri, 08 July 2011 01:06

Michel Cadot
Messages: 54146
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Maybe because this people is just little.
You just come here once and think you are able to judge other.
Maybe if you'd answer 300 times to one that seems to learn and understand nothing you will also post some sarcastic sentences.

What's the point to register just to post this in a 2 years old topic? You should better try to find a question you can answer and help instead of "wasting our time with off topic comment".

Regards
Michel

Report message to a moderator