Archives of the TeradataForum

Message Posted: Sun, 01 Oct 2001 @ 16:34:17 GMT

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

Ruth,

This may sound like it's coming out of left field, but is the SQL in the MLOAD properly tuned? If I'm understanding your stats correctly, the MLOAD is consuming over 16 Million CPU seconds to load about 112 Million rows. I don't know much about your data model, etc., but that seems like a tremendous amount of CPU power to process that many rows. Is it possible that the target table is a VERY non- unique NUPI, the table is a SET table, and the rows are very long? Does this process use this much CPU when there are no NUSI indices?

BTW, where did you get these stats? DBC.AMPUSAGE?

Regards,

Thomas F. Stanek
TFS Consulting

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