Optimized select into in SQL Server 2014

Lets have quick glance of this feature.
As we all know select .... into clause and how to use it.
Now in SQL 2014 its more optimized and will operate in parallel also for better performance.


Lets see with example

I have one table test_table with 200 Million records in SQL Server 2014 and 2012 both.

We will run Select .... into query and check execution plan



SQL Server 2012

SELECT *
INTO   new_table
FROM   xyz




SQL Server 2014


SELECT *
INTO   new_table
FROM   xyz






As we can see in execution plan optimizer is using parallelism operator to dump data.


No comments:

Post a Comment

Amazon Contextual Product Ads

Popular Posts