My off-the-cuff response would be that increasing the threads for a full table scan would improve performance if the individual server process doing the scan was the bottleneck in some way. If the operation is bottlenecked on something else (like mechanical disk, for example), then increasing the number of CPU threads may do very little. It is very environment and workload specific in other words.
jeff_browning
256 Posts
0
October 25th, 2013 05:00
My off-the-cuff response would be that increasing the threads for a full table scan would improve performance if the individual server process doing the scan was the bottleneck in some way. If the operation is bottlenecked on something else (like mechanical disk, for example), then increasing the number of CPU threads may do very little. It is very environment and workload specific in other words.