Re: Join Predicate Question

> 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'
>

Maybe in the first statement oracle first reads the records from table Claims and apply the filter so the rows returned for the join with the other table are fewer than the second case and the resulting join is lighter.

Try both query with explain plan and see if there is a difference in the resulting plan. Received on Thu Sep 19 2002 - 06:46:13 CDT