Archives of the TeradataForum

Message Posted: Fri, 27 Jan 2006 @ 20:03:34 GMT

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

I agree that MULTISET tables violates Relational theory. The biggest reason to use MULTISET tables is performance. Using MULTISET tables avoid duplicate row checks which really slows down inserts with non unique primary index where you have lots of rows per primary index value. Only other way to do this is to have a unique index which may be a bigger performance drain. However, I firmly believe that if you use MULTISET tables you must ensure Relational Integrity in your ETL processes.

Thanks,

Bob Diehl

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