Re: Oracle SQL Condition Question...

Suresh Easwar wrote:
>
> 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

Try,,,,
Insert into tab3 (select * from tab1 where

   NOT EXISTS(select tab2.f2 from tab2));

This should be close anyway. To insert rows from tab1 where (not in tab2)
Doing this from memory. So the syntax might be off. Received on Mon Apr 20 1998 - 00:00:00 CDT