Re: What does the (+) operator mean in sql queries?

Pablo Sanchez wrote:
>
> "Galen Boyer" <galenboyer_at_hotpop.com> wrote in message
> news:ulmbo1bkl.fsf_at_rcn.com...
> > On Sun, 14 Apr 2002, RubberDucky703_at_hotmail.com wrote:
> >
> > > How does the outer join work?
> >
> > CONSIDER:
> >
> > [ snipped ]
>
> And to add to this excellent example:
>
> Find me data that is _not_ in t2 but is in t1 - in other words, how
> can I find data that is missing in t2 quickly and efficiently?
>
> SQL> select * from t1,t2 where t1.fld1 = t2.fld1 (+) and t2.fld1 IS
> NULL;
>
> FLD1 FLD1
> ---------- ----------
> 1
> 3
> --
> Pablo Sanchez, High-Performance Database Engineering
> mailto:pablo_at_hpdbe.com
> Available for short-term and long-term contracts

Quickly and efficiently? High-Performance? Are you sure this is quicker and more efficient than the "not exists"? Maybe a "minus" would even be more performant to answer your problem. Try it!

-- 

Gerard H. Pille

(The Beatles Reunion is neigh!)