Re: Slow insert

From: Em Pradhan <empradhan_at_dplus.net>
Date: Fri, 11 Dec 1998 01:54:22 -0500
Message-ID: <3670C19E.12702A9@dplus.net>

Try this one

    create table C
    as (select * from TABLEB

         MINUS
         select * from TABLEA);

then insert..

    insert into TABLEA select * from table C;

Hope it helps ...

Lito Dizon wrote:

> Why is this so slow? Slow meaning 10 hours. Ans the
> further it gets, the slower it gets.
>
> insert into TABLEA
> select * from TABLEB
> where KEY not in (select KEY from TABLEA )
>
> Both tables are indexed on KEY. TABLEA has 9000 rows
> while TABLE B has 12000 rows.
Received on Fri Dec 11 1998 - 00:54:22 CST