Archives of the TeradataForum

Message Posted: Wed, 03 Nov 2010 @ 10:56:10 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Prasad,

when using a multistatement, all insert-selects output to the same spool table and this one is inserted into your target table in the end. So, you naturally need more spool to treat the inserts via MSR. However, once all data is in the spool, the insert into an empty table is much faster, because you avoid transient journal.

Maybe there is a way to optimize your request, but basically, I would recommend to increase the spool of your user.

Tomas Gorner

	<Prev	Next>		<<First	<Prev	Next>	Last>>