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.

Report message to a moderator

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: 26766
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

Report message to a moderator

Re: explain plan [message #383747 is a reply to message #383745] Thu, 29 January 2009 23:23 Go to previous message
Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Previous Topic: Materialized View Vs Table functions
Next Topic: Range Hash Partitioning vs. range partition plus B Tree index (merged)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 16 04:45:03 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.