This discussion is archived
5 Replies Latest reply: Jan 18, 2013 2:39 AM by Nikolay Savvinov RSS

does sql sql efficiency depend on order of join predicate?

yash_08031983 Newbie
Currently Being Moderated
hello experts,

I trying to under stand the explain plan , I read the link

Example 3: The inefficiency is coming from the wrong join order, where the bigger row source is taken as the driving table.
please explain.



  • Correct Answers - 10 points
  • Helpful Answers - 5 points