Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

Index.MaximumDegreeOfParallelism Property

Gets or sets the maximum number of processors that can be used when running a query that uses the index.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public int MaximumDegreeOfParallelism { get; set; }

Property Value

Type: System.Int32
An Int32 value that specifies the maximum number of processors that can be used when running a query that uses this index.

If this property is not set, the system default is used.

NoteNote

For indexes based on the UserDefinedTableType object the value of the IsXmlIndex property is always false.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.