SQLServerCentral » Latest topics
Max. Degree or Parallelism
Afternoon All,
Sometimes setting MAXDOP 1 for a query results in a faster execution. Is this simply because the process of re-constructing the various split up streams is a costly operation and sometimes the cost of re-assembly outweigh the benef
Sometimes setting MAXDOP 1 for a query results in a faster execution. Is this simply because the process of re-constructing the various split up streams is a costly operation and sometimes the cost of re-assembly outweigh the benef
No comments:
Post a Comment