Re: Oracle SQL Condition Question...

From: Bob Cunningham <bcunn_at_oanet.com>
Date: 1998/04/21
Message-ID: <353bfe95.94755346@news.oanet.com>#1/1

On 20 Apr 1998 18:39:36 GMT, gosar_at_EBB.Eng.Sun.COM (Bhavesh Gosar) wrote:

>Hi,
>
>I have 2 tables
>
>tab1 tab2
>==== ====
>.. ..
>.. ..
>f1 f2
>.. ..
>.. ..
>
>Both the tables above contain approx. 60,000 Records
>and have indexes on f1 and f2.
>
>I have an SQL which is the foll..
>
>Insert into tab3 ( select * from tab1 where tab1.f1 not in
> (select distinct tab2.f2 from tab2));

You might try:

INSERT INTO tab3

(SELECT *

      FROM tab1
     WHERE NOT EXISTS (SELECT 'x'
                         FROM tab2
                        WHERE tab2.f2 = tab1.f1
                      )

);

>
>The problem is this SQL takes around 40-45 hours to execute...
>
>Am i missing something here...Or any Workarounds Possible...??
>
>TIA,
>Bg
>
>
>

Bob Cunningham
bcunn_at_oanet.com Received on Tue Apr 21 1998 - 00:00:00 CDT