Home » RDBMS Server » Performance Tuning » explain plan (oeacle 10g)
explain plan [message #383745] Thu, 29 January 2009 23:17 Go to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
what is the way to understand the explain plan concepts.how to proceed the sequence of it involved in it.
Re: explain plan [message #383746 is a reply to message #383745] Thu, 29 January 2009 23:22 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
Are you unwilling or incapable to Read The Fine Manual?
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9010.htm
Re: explain plan [message #383747 is a reply to message #383745] Thu, 29 January 2009 23:23 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
A good start
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/ex_plan.htm#i16971
Previous Topic: Materialized View Vs Table functions
Next Topic: Range Hash Partitioning vs. range partition plus B Tree index (merged)
Goto Forum:
  


Current Time: Sat Dec 03 09:37:21 CST 2016

Total time taken to generate the page: 0.09217 seconds