Archives of the TeradataForum

Message Posted: Wed, 26 Sep 2007 @ 11:56:02 GMT

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

I am trying to do an insert/select into an empty table from a table with 177,235,617 rows. Both tables are identical except the target table has some of the fields defined as varchar instead of char. The primary index is the same (NUPI). If it makes a difference, both tables are partitioned by date. There are no secondary indices.

I read a post on the forum where someone mentioned that having statistics collected on the source table made a difference, so I made sure that statistics were collected.

I?m sure this must not be an uncommon thing. Any suggestions as to how to load this data into a new table would be greatly appreciated.

Thanks

Craig

Sr. Database Administrator
WESCO Distribution, Inc.

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