Home » SQL & PL/SQL » Client Tools » Explain plan Using toad and SQL Developer (oracle 10g,)
Explain plan Using toad and SQL Developer [message #411361] Fri, 03 July 2009 04:26 Go to next message
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
Re: Explain plan Using toad and SQL Developer [message #411363 is a reply to message #411361] Fri, 03 July 2009 04:33 Go to previous messageGo to next message
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
Re: Explain plan Using toad and SQL Developer [message #411366 is a reply to message #411363] Fri, 03 July 2009 04:44 Go to previous messageGo to next message
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.
Re: Explain plan Using toad and SQL Developer [message #411367 is a reply to message #411366] Fri, 03 July 2009 04:46 Go to previous messageGo to next message
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;
Re: Explain plan Using toad and SQL Developer [message #411370 is a reply to message #411361] Fri, 03 July 2009 05:04 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Alternatively,
SET AUTOTRACE ON, a SQL Plus command.

regards,
Delna
Re: Explain plan Using toad and SQL Developer [message #411372 is a reply to message #411366] Fri, 03 July 2009 05:15 Go to previous messageGo to next message
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.
Re: Explain plan Using toad and SQL Developer [message #411373 is a reply to message #411370] Fri, 03 July 2009 05:15 Go to previous messageGo to next message
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?


Re: Explain plan Using toad and SQL Developer [message #411374 is a reply to message #411373] Fri, 03 July 2009 05:16 Go to previous messageGo to next message
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
Re: Explain plan Using toad and SQL Developer [message #411386 is a reply to message #411372] Fri, 03 July 2009 05:55 Go to previous messageGo to next message
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
Re: Explain plan Using toad and SQL Developer [message #411409 is a reply to message #411386] Fri, 03 July 2009 07:28 Go to previous messageGo to next message
thatjeffsmith
Messages: 38
Registered: July 2009
Location: Raleigh, NC
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.


Re: Explain plan Using toad and SQL Developer [message #411420 is a reply to message #411409] Fri, 03 July 2009 08:13 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: Explain plan Using toad and SQL Developer [message #411460 is a reply to message #411421] Sat, 04 July 2009 01:45 Go to previous messageGo to next message
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

Re: Explain plan Using toad and SQL Developer [message #411507 is a reply to message #411460] Sat, 04 July 2009 08:06 Go to previous messageGo to next message
pablolee
Messages: 2634
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?
Re: Explain plan Using toad and SQL Developer [message #411530 is a reply to message #411460] Sat, 04 July 2009 14:12 Go to previous messageGo to next message
Littlefoot
Messages: 19650
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.
Re: Explain plan Using toad and SQL Developer [message #411604 is a reply to message #411530] Sun, 05 July 2009 23:50 Go to previous messageGo to next message
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

Re: Explain plan Using toad and SQL Developer [message #427571 is a reply to message #411361] Fri, 23 October 2009 05:07 Go to previous messageGo to next message
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.
Re: Explain plan Using toad and SQL Developer [message #427572 is a reply to message #427571] Fri, 23 October 2009 05:10 Go to previous messageGo to next message
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..
Re: Explain plan Using toad and SQL Developer [message #515044 is a reply to message #427571] Thu, 07 July 2011 20:26 Go to previous messageGo to next message
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.
Re: Explain plan Using toad and SQL Developer [message #515046 is a reply to message #515044] Thu, 07 July 2011 21:33 Go to previous messageGo to next message
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.
Re: Explain plan Using toad and SQL Developer [message #515071 is a reply to message #515046] Fri, 08 July 2011 01:06 Go to previous messageGo to next message
Michel Cadot
Messages: 59291
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
Re: Explain plan Using toad and SQL Developer [message #515128 is a reply to message #515044] Fri, 08 July 2011 03:14 Go to previous messageGo to next message
pablolee
Messages: 2634
Registered: May 2007
Location: Scotland
Senior Member
I would love to hear why you think this little bit of thread necromancy isn't a rather sad little waste of time.
Re: Explain plan Using toad and SQL Developer [message #515186 is a reply to message #515071] Fri, 08 July 2011 07:47 Go to previous messageGo to next message
no_spam77
Messages: 2
Registered: July 2011
Location: Durham NC
Junior Member
Answering 300 or 3000 times doesn't give one a license to abuse people.
Re: Explain plan Using toad and SQL Developer [message #515188 is a reply to message #515186] Fri, 08 July 2011 08:02 Go to previous message
Michel Cadot
Messages: 59291
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You're just a troll.

Topic is locked.

Regards
Michel
Previous Topic: Import Problem with SQL Developer v 2.1.1.64 and Excel Files
Next Topic: Need Reporting tool
Goto Forum:
  


Current Time: Wed Oct 01 23:01:32 CDT 2014

Total time taken to generate the page: 0.15227 seconds