Home » SQL & PL/SQL » SQL & PL/SQL » Need to know about some basic for explain plan (Oracle, Oracle Database 11g Express Edition Release 11.2.0.2.0 ,Win 7 Pro)
Need to know about some basic for explain plan [message #636053] Wed, 15 April 2015 11:18 Go to next message
shumail
Messages: 149
Registered: September 2012
Location: Canada
Senior Member
Hi All

I really appreciate if someone help me out to learn explain plan.
I tried to Google it but unable to find simplest tutorial.
Thanks in advance

Regards
Shu

Report message to a moderator

Re: Need to know about some basic for explain plan [message #636054 is a reply to message #636053] Wed, 15 April 2015 11:25 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
when all else fails Read The Fine Manual

https://docs.oracle.com/apps/search/search.jsp?category=database&product=e50529-01&q=explain+plan

Report message to a moderator

Re: Need to know about some basic for explain plan [message #636055 is a reply to message #636054] Wed, 15 April 2015 11:44 Go to previous messageGo to next message
shumail
Messages: 149
Registered: September 2012
Location: Canada
Senior Member
Hi BlackSwan
Thanks for the link and I really appreciate it,
I went through your provided link and I'm wondering that it looks like advance level document, Can you provide me some link for a simple tutorial?. appreciate your help. Thanks

Regards
Shu

Report message to a moderator

Re: Need to know about some basic for explain plan [message #636056 is a reply to message #636055] Wed, 15 April 2015 11:47 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://docs.oracle.com/database/121/TGSQL/tgsql_interp.htm#TGSQL277

Report message to a moderator

Re: Need to know about some basic for explain plan [message #636057 is a reply to message #636053] Wed, 15 April 2015 12:12 Go to previous messageGo to next message
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
Senior Member
I recorded this simple tutorail a while back, it has had some nice comments

http://skillbuilders.com/webinars/webinar.cfm?id=98&w=Oracle-SQL-Tuning-Execution-Plans-for-Beginners

Report message to a moderator

Re: Need to know about some basic for explain plan [message #636069 is a reply to message #636053] Wed, 15 April 2015 21:16 Go to previous messageGo to next message
shumail
Messages: 149
Registered: September 2012
Location: Canada
Senior Member
Thank you guys, I really appreciate your help.....

Report message to a moderator

Re: Need to know about some basic for explain plan [message #636083 is a reply to message #636069] Thu, 16 April 2015 07:01 Go to previous message
mnitu
Messages: 159
Registered: February 2008
Location: Reims
Senior Member
Jonathan Lewis has started an extended tutorial at AllThingsOracle about executions plans.

Report message to a moderator

Previous Topic: Procedure altered with compilation errors
Next Topic: get data from two tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 08:05:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.