Re: Oracle expert please help. Slow insert in Oracle 8i and 9i. Urgent!

Uzytkownik "kokoiski" <kokoiski_at_gawab.com>
> INSERT INTO TABLE1(col1,col2,col3...col8)
> SELECT col1,col2,col3...col8 FROM TEMP_TABLE a
> WHERE NOT EXISTS(SELECT 1 FROM TABLE1 b
> WHERE a.col1 = b.col1
> AND a.col2 = b.col2
> AND a.col3 = b.col3
> AND a.col4 = b.col4
> AND a.col5 = b.col5)

INSERT INTO TABLE1(col1,col2,col3...col8)  SELECT col1,col2,col3,...,col8

    FROM TEMP_TABLE
WHERE (col1,col2,col3,col4,col5)
IN
 (
 SELECT col1,col2,col3,col4,col5

    FROM TEMP_TABLE
  MINUS
 SELECT col1,col2,col3,col4,col5
   FROM TABLE1
);

How fast performs this one ?

--
Noel