Archives of the TeradataForum

Message Posted: Thu, 06 May 2004 @ 08:18:09 GMT

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

If you want your table to be always free of duplicates, consider using SET instead of MULTISET option in the table definition. That's a typical feature of TD you probably won't find in Oracle.

SET does add performance overhead with each DML, though, which might be quite visible with larger tables. In that case you might be better off using MULTISET and the query as above scheduled to run after all DML.

Regards,

Victor

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