INSERT . . . SELECT Into an Empty SET Table
INSERT . . . SELECT into an empty SET table from a source known not to have duplicate rows avoids duplicate checking of the target table during insertion. This occurs even during direct insertion from another SET table.
This should offer significant performance improvement in cases where there is a NUPI that is relatively nonunique or has few values that are very nonunique.