Sql 2016 Insert Select Paralel

Select … into  newTable  could be a parallel operation. But Insert … Select was NOT.

 

Starting with sql server 2016, Insert … Select could be parallel.

There are some additional conditions:

• use TABLOCK  :

 insert into aTable with (TABLOCK)

select ….

• compatibility level 130.
• heap table or column-stored clustered table (not  for clustered table)

 

S