Archives of the TeradataForum
Message Posted: Mon, 16 Jul 2012 @ 15:19:56 GMT
It is probably a NUPI dup (non unique primary index problem). This occurs because of duplicate row checking.
Make sure the primary index choice is unique or nearly unique.
You can also make the table multiset to avoid duplicate row checking. However, you know have to worry about duplicate rows. Also the table will be skewed so performance will suffer.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|