Archives of the TeradataForum

Message Posted: Wed, 23 Nov 2005 @ 11:30:00 GMT

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

Also ran into this problem at my site, with some data mart tables where we were using csum to create unique identifiers.

We redefined the tables to use identity columns for the unique identifier field, which avoided the spool issue.

Also seemed to perform a little better.

Regards,

Dave

__________________________________
David W. Roth
Teradata Certified Master
TERADATA, a Division of NCR

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