On Thu, Mar 12, 2009 at 8:41 AM, mos <mos99@stripped> wrote:
> I have 3 tables that are 1:1 and will always have a row for a given
> product,_code & date. If I want to join them together, is it going to be
> faster to use an equi join or a left join, or does it matter?
IIRC:With an inner join the optimizer has more latitude to reorganize
the join order and can short circuit the process if there is not a
This is completely secondary to getting the right result set for your
query. If there is the possibility of a row in the parent table not
joining and needing to be part of the result then you must use left.