Using Oracle 11 (still). CST_ITEM_COST_DETAILS
I'm looking at the data in BOM.CST_ITEM_COST_DETAILS.
We have 105 million records in that table. We have duplicate records in the table.
I have queried across all columns and there is apparently no unique key.
How can this be?
I don't really know what the data is, but it's data modeling 101 to put a primary key on all tables.
Can anyone explain why it would be ok to have duplicate records...literally the data in every column matches.
Thanks in advance. :)