Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Join Predicate Question

Join Predicate Question

From: dudester <mochaone_at_zdnetmail.com>
Date: Tue, 17 Sep 2002 22:06:09 -0400
Message-ID: <3D87DF91.6050705@zdnetmail.com>


Let's say you have the following query:

Select
 From Claims C Inner Join

      Members M
On C.EmpID = M.EmpID

I understand what that does. But what if you have the following:

Select
 From Claims C Inner Join

      Members M
On C.EmpID = M.EmpID
and C.BirthDt >= '1980-01-01'

Is that more efficient that placing the additional predicate in a Where clause? I guess I'm trying to find out if there is any difference between that statement and this one:

Select
 From Claims C Inner Join

      Members M
On C.EmpID = M.EmpID
Where C.BirthDt >= '1980-01-01' Received on Tue Sep 17 2002 - 21:06:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US