Archives of the TeradataForum
Message Posted: Sun, 01 Oct 2001 @ 16:34:17 GMT
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?
Thomas F. Stanek
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|