Archives of the TeradataForum
Message Posted: Tue, 24 Jan 2012 @ 20:58:14 GMT
| Subj: || || Re: Unique index vs. primary index |
| From: || || Poston, Donna |
Hi Gabriel, you are getting more than one row that shares the same value for column prod_id. If you want to use the single column prod_id as a
primary index, the PI should be a NUPI.
You should check the demographics of the prod_id and make sure there are not a lot of hash collisions for a give Primary index value. If the
table is SET having a NUPI of prod_id, there can be a lot of duplicate row checks. A multiset table will not check for duplicate rows, but an
exact duplicate can load to the table unless these are filtered out.