5 Replies Latest reply: Jan 18, 2013 4:39 AM by Nikolay Savvinov RSS

    does sql sql efficiency depend on order of join predicate?

    yash_08031983
      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