Insert- Select data from UPI to NOPI table

Database

Insert- Select data from UPI to NOPI table

While INSERT- SELECT from a UPI table to a NOPI table the data from the source table will not be distributed and will be locally appended to the target table.

The rows will be placed on the same AMP as of the original table row.

Will the rows be sorted??

Tags (1)
1 REPLY
Senior Apprentice

Re: Insert- Select data from UPI to NOPI table

The rows will be insertd as-is, i.e. no additional sort.