Archives of the TeradataForum
Message Posted: Wed, 05 Dec 2012 @ 10:15:00 GMT
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.
Sughesh I S.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|