better quey then this

[hiku]

Hello,
I am trying to insert records in a table say "TableB"
from "TableA". If a record does not exist in Tableb
then and then insert record from tableA.
as of now my query is
insert tableB
select * from tableA
where id not in(select id from tableB).
I am working with about 200000 records. This query is taking too long. Does any one have a better suggestion.
Thanx for your time.
Hiku

[Khan]

why don't u use "SELECT INTO" instead of select * from tbl

------------
hiku at 5/18/00 4:03:57 PM

Hello,
I am trying to insert records in a table say "TableB"
from "TableA". If a record does not exist in Tableb
then and then insert record from tableA.
as of now my query is
insert tableB
select * from tableA
where id not in(select id from tableB).
I am working with about 200000 records. This query is taking too long. Does any one have a better suggestion.
Thanx for your time.
Hiku