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

INTO   new_table
FROM   xyz

SQL Server 2014

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