Excellent article Jonathan, thanks for pointing it out. Jared On Apr 6, 2005 5:42 PM, Jonathan Gennick <jonathan@xxxxxxxxxxx> wrote: > > Hello Paul, > > It *can* make a difference when you move a predicate from the > WHERE clause into the JOIN clause. (It surprised me too) Have a look > at the following article: > > http://www.oreillynet.com/pub/a/network/2002/10/01/whatsinacondition.html > > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- //www.freelists.org/webpage/oracle-l