| http://www.w3.org/ns/prov#value | - Below is a script to change the instance level setting from 0 (all processors) to 2.EXEC sys.sp_configure N'max degree of parallelism', N'2'GORECONFIGURE WITH OVERRIDEGOAll running the query again, here are the results.The cost is now 6.38581 and only 2 threads.
|
