Re: insert into select ... very very slow

From: Korotky Dmitry <jedi_at_entecheco.com>
Date: Tue, 23 Apr 2002 17:11:53 +0300
Message-ID: <aa3q1h$u56$1@entecheco.com>

> ok but each day I should udpated the table
> I must use insert statement
> Bruno

Maybe the destination table contents indexes, constraints or triggers. All of this may decrease the speed of inserting rows. In this case, you may drop them before inserting and create them again after one.

And if the number of inserting rows is about 10000 and more then you should insert them by small portions (1000 rows per portion for example). It is bacause the rollback segment may overflow...

May the Force be with you!
Jedi

jedi_at_entecheco.com Received on Tue Apr 23 2002 - 09:11:53 CDT