Archives of the TeradataForum

Message Posted: Fri, 30 Nov 2012 @ 22:22:02 GMT

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

Hi Ray,

Thanks for the response. I ran tests with various combinations of PACK and SESSION factor. I noticed that having SESSION = 20 / SESSION =40 didn't make any difference. Below are the results I got for 1.1 Million records.

PACK = 20 and SESSION = 2 - It took 2.5 hours PACK = 20 and SESSION = 20 - It took 17 minutes - This I believe is a good combination.

Thanks

Roopalini

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