Minimal Logging with INSERT…SELECT into Empty Clustered Tables
SQL Performance
MAY 16, 2019
If both sort and no-sort alternatives are available, the optimizer will make a cost-based choice. dbo.Test (id)' ; (If you run the script on SQL Server 2012 or earlier, change the TOP clause in the script from 268 to 252, for reasons that will be explained in a moment.). SQL Server 2012. spt_values AS SV ; Plan Caching.
Let's personalize your content