create set table vs. create multiset table

Database

create set table vs. create multiset table

If my table will always have a  unique primary or secondary  index, does it still

Make sense to use create set table statement to create tables. I come from Oracle and SQL

Server background where there is nothing like set or multiset, everything implicitly is multiset.

I am assuming if one uses create set table; Teradata is doing additional work of checking that row is

Not duplicate.

Appreciate your insight.

2 REPLIES

Re: create set table vs. create multiset table

Hi,

If you have unique index defined on a table, then duplicate row check will be performed at index level, and multiset and set table will not make any difference.

Khurram

Re: create set table vs. create multiset table

Something new I learnt.