I understand that a SET table has an overhead of checking for duplicate rows while data is being inserted into the table. However, if the table has a UPI/USI defined on it, only the UPI/USI columns are checked for duplicates and not duplicate row checks. Is this understanding correct ?

Can existing table with Data, defined as SET be changed to MULTISET Table without dropping and re-creating the table?