Re: Oracle SQL Condition Question...
From: Ajay Kulkarni <ajay_at_ifu.net>
Date: 1998/04/23
Message-ID: <01bd6e56$d829c1e0$52e4e6d0_at_ifu.ifu.net>#1/1
> > 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...??
> >
Received on Thu Apr 23 1998 - 00:00:00 CEST
Date: 1998/04/23
Message-ID: <01bd6e56$d829c1e0$52e4e6d0_at_ifu.ifu.net>#1/1
To improve the processing time use the following query
insert into tab3
select f1 from tab1
minus
select f2 from tab2
I am pretty sure this will give the same results and will run in a substantially smaller time.
Ajay
akulkar_at_ifu.net
> > 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...??
> >
Received on Thu Apr 23 1998 - 00:00:00 CEST