Oracle SQL Condition Question...

Hi,

I have 2 tables

tab1 tab2
==== ====
.. ..
.. ..

f1     f2


..     ..

..     ..

[Quoted] [Quoted] Both the tables above contain approx. 60,000 Records [Quoted] and have indexes on f1 and f2.

I have an SQL which is the foll..

[Quoted] [Quoted] Insert into tab3 ( select * from tab1 where tab1.f1 not in

                         (select distinct tab2.f2 from tab2));

[Quoted] [Quoted] [Quoted] [Quoted] [Quoted] [Quoted] [Quoted] [Quoted] The problem is this SQL takes around 40-45 hours to execute...

[Quoted] Am i missing something here...Or any Workarounds Possible...??

TIA,
Bg Received on Mon Apr 20 1998 - 00:00:00 CEST