Archives of the TeradataForum

Message Posted: Fri, 26 Apr 2002 @ 14:27:10 GMT

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

Successfully populated a new table converting 5 full dates thru an Insert/Select and CASE on each date. 52 million rows took just about three hours during the workday on an old 4-node 4700 without any apparent degradation of performance.

Thanks all for your help and to Mike Larkins for his class on optimizing CASE at Midwest TUG on April 23rd in Dayton.

John Balchunas
Jefferson County Public Schools

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