Archives of the TeradataForum

Message Posted: Mon, 16 Jul 2012 @ 18:48:02 GMT

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

Hi,

Firstly, is your processing blocked? Use Viewpoint or Pmon or 'whatever' to find out.

Secondly, what volume of rows are you talking about?

Also consider if the target table is already populated. If it is then each inserted row will be written to the Transient Journal. This will slow down the processing.

If this is the case then can you merge both tables into one new one ? I've seen that run a lot quicker than what you are currently trying to do. But, again, you have to consider volume. If you are trying to add 250 rows a 250 million row table, then just do it (but it shouldn't take 4 hours). If you are trying to 250 million rows to 250 rows, then reverse the logic (if you can). If you are trying ot combine two 250 million row tables, then probably try merging them into a third, empty table - use two insert/selects coded as an MSR.

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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