Archives of the TeradataForum
Message Posted: Thu, 06 May 2004 @ 08:18:09 GMT
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.
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023