Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DBADave
Constraint Violating Yak Guru
366 Posts |
 Posted - 2009-01-23 : 20:10:02
|
| When using MAXDOP with ALTER INDEX does MAXDOP only apply to the execution of ALTER INDEX or does it also apply to the index itself, meaning any time the index is invoked the MAXDOP setting takes effect? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-25 : 22:27:17
|
| Booksonline has details:http://msdn.microsoft.com/en-us/library/ms188388.aspx |
 |
|
|
DBADave
Constraint Violating Yak Guru
366 Posts |
Posted - 2009-01-26 : 08:07:28
|
| The BOL quote is the reason I posted my question. It states:Overrides the max degree of parallelism configuration option for the duration of the index operation. For more information, see max degree of parallelism Option. Use MAXDOP to limit the number of processors used in a parallel plan execution. The maximum is 64 processors. That statement can be interpreted as meaning MAXDOP applies per invocation of the index, which I found out since posting this question that is not how it applies to ALTER INDEX. I've been told by a few people that using MAXDOP with ALTER INDEX only affects how the ALTER INDEX command executes, not subsequent invocations of the index itself.Dave |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-26 : 08:34:32
|
They are right.It only affects the creating/alteration of the index.Any future use of the index will be evaluated by the Query Engine (and in some cases the Storage Engine).
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
How does MAXDOP work with ALTER INDEX?