Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Different syntax for LEFT JOIN

Re: Different syntax for LEFT JOIN

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sun, 28 Nov 2004 12:54:43 -0800
Message-ID: <1101675191.31349@yasure>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US