Hi All
I have a question regarding each of the following SQL statements. Can anyone tell me if there are any performance improvements/enhancements in ORACLE when using either Query 2 or Query 3 compared to the traditional way of writing outer join queries?
As an example, I have the following SQL queries which will identify orders which exist in the master/header table, but do not have lines.
Query 1 (Traditional way to write outer join queries)
SELECT * FROM customer_order_tab a
, customer_order_line_tab b
where a.order_no = b.order_no(+)
and a.order_no = 'C10236'
Query 2 (using LEFT outer joins)
SELECT * FROM customer_order_tab a
LEFT OUTER JOIN customer_order_line_tab b
ON a.order_no = b.order_no
WHERE a.order_no = 'C10236'
Query 3 (using RIGHT outer joins)
SELECT * FROM customer_order_line_tab a
RIGHT OUTER JOIN customer_order_tab b
ON a.order_no = b.order_no
WHERE b.order_no = 'C10236'
Thanks
