Archives of the TeradataForum

Message Posted: Wed, 05 Dec 2012 @ 10:15:00 GMT

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

Hi Roopa,

Please find details below.

1. As you have defined a UPI, there won't be any duplicate check, with rows coming against rows exist.

2. As you have defined a UPI, there won't be any performance degradation. But if you defined only PI, TD will always do duplicate row check with all rows present in table. So there will be considerable degradation.

3. If you are using UPI, there is no improvement. But if you are using PI, there will be.

Thanks,

Sughesh I S.

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