Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Join Predicate Question
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 Wed Sep 18 2002 - 07:38:26 CDT