Swaminathan K
asked on
need help on explain plan oracle sql
Hi ,
Iam new to sql tuning , I have been asked to run an explain plan for an query and provide possible solutions for tuning thehelp query
I need help on reading and analyzing the explain plan, below is the output of my plan table , any help in explaining the plan is very much appreciated.
Attached is the plan . Kindly help me in understanding the output.
sql1.txt
Iam new to sql tuning , I have been asked to run an explain plan for an query and provide possible solutions for tuning thehelp query
I need help on reading and analyzing the explain plan, below is the output of my plan table , any help in explaining the plan is very much appreciated.
Attached is the plan . Kindly help me in understanding the output.
sql1.txt
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.