Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Different syntax for LEFT JOIN
Ruslan Kogan wrote:
> Does anyone else have any view points on the performance differences
> between the ISO and ANSI sql standards?
>
> Is one an industry preferred standard?
The ISO syntax is preferred in most Oracle shops mostly because that is what Oracle developers have been using since as far back as any of us can remember.
I quickly created the following:
set serveroutput on
DECLARE
CURSOR t_cur IS
SELECT s.prod_id, s.cust_id, s.time_id, s.promo_id
FROM sales s, customers c
WHERE s.cust_id = c.cust_id;
/*
CURSOR t_cur IS
SELECT s.prod_id, s.cust_id, s.time_id, s.promo_id
FROM sales s INNER JOIN customers c
ON s.cust_id = c.cust_id;
*/
i PLS_INTEGER;
BEGIN
i := dbms_utility.get_time;
FOR t_rec IN t_cur
LOOP
NULL;
END LOOP;
dbms_output.put_line(dbms_utility.get_time - i);
END;
/
and ran it both ways 5 times using the SH schema and can't find any difference between the two after the first run of each.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Sun Nov 28 2004 - 14:54:43 CST