Export (0) Print
Expand All

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.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Matrix)]
public int MaximumDegreeOfParallelism { get; set; }

Property Value

Type: 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2015 Microsoft