|
|
Posted by adi on 10/07/92 11:30
Having used this approach I still want to improve its performance.
My DBA says that splitting the insert statement into smaller chunks
will be very helpful - that is insert n number of records at a time.
so if I have 1 million rows to insert, he says its good to insert 50k
at a time.
Can someone help me on how to split the below insert to do that?
insert into datatable(field1, field2, field3)
select a1, a2, a3 from temptable.
Navigation:
[Reply to this message]
|