Archives of the TeradataForum

Message Posted: Fri, 01 Mar 2002 @ 14:39:54 GMT

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

Shridhar

I note you are appending rows - each will be journalled and the time taken becomes evident on thousands of rows. In addition to the suggestions already made, consider loading to a (temporary) empty table. Then merge the old table and the temporary table into a new table with a single journal entry.

Ken Hansen

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