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
http://savvinov.com/2012/06/11/sql-efficiency/

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

thanks
yahs

Legend

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