differences between Volatile table and multiset volatile table

Database
Enthusiast

differences between Volatile table and multiset volatile table

Hi All, 

 

I understand that multiset table allows duplicates ?Does volatile table allow duplicates?

 

how does unique index and Primary Index act for the same table?

 

Thanks

1 REPLY
Teradata Employee

Re: differences between Volatile table and multiset volatile table

I believe in terms of Multiset/Set and UPI/PI volatile table behaves same as a permanent table.