Re: Where clause and cartesian product

Mark,

> your SQL statement is the equivalent of
>
> select job_id, dept_name
> from employees e join departments d using (dept_id)
>
> which is the equivalent of
>
> select job_id, dept_name
> from employees e join departments d on (d.dept_id = e.dept_id)
>
> they are all different valid syntaxes for an inner join, and the oracle
> optimizer determines the most efficient way to retrieve the rows, using any
> available indexes to reduce the amount of data examined (no cartesian
> products are involved in any joins, no matter the syntax)

Thanks for your patient exposition. I feel much better off in understanding different ways of writing the same select command.

> (also you'll do well not top-posting... it gets folks in these forums kinda
> ticked off)
>

Thanks again for the lead. Would resort to inline replies from now on.

regards,
Hari
India Received on Wed Dec 14 2005 - 00:06:20 CST