Re: Oracle SQL Condition Question...

From: Suresh Easwar <sje_at_sigma-inc.com>
Date: 1998/04/20
Message-ID: <353BD7D6.BE5D220D@sigma-inc.com>#1/1

try:

    insert into tab3
    select * from tab1
    where f1 in (select f1 from tab1 minus select f2 from tab2)

also, resorting to pl-sql will certainly speed things up.

good luck
Suresh

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));
>
> The problem is this SQL takes around 40-45 hours to execute...
>
> Am i missing something here...Or any Workarounds Possible...??
>
> TIA,
> Bg
Received on Mon Apr 20 1998 - 00:00:00 CDT