Archives of the TeradataForum

Message Posted: Fri, 08 Dec 2006 @ 17:58:23 GMT

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

Greetings!

According to the previous post

"There is only one date in the table at a time. The reason it is paritioned is becuase it improves the insert performance into another table that is partitioned by day as well."

You're going to get the same number of I/O's on either insert. Since the entire staging table is encapsulated within one partition, your pushing the entire table/partition into your ELT stream. There isn't any partition to eliminate, as the table has only one date and that is the partitioning column.

Assuming your staging partition is intended to populate only one (hopefully!) partition on your target table, you should be able to reduce the perf hit on the transient journal.

If the goal is to improve performance (doh!) other questions come to mind:

1. Do the source and target tables have the same PI?

2. Are the source and target tables SET or MULTISET? UPI's? NUPI's?

3. Are there any underlying JI's, (N)USI's?

Blaine M. Vande Berg
Senior Technical Consultant

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