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
SQL Server 2014
As we can see in execution plan optimizer is using parallelism operator to dump data.
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
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