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 Property MaximumDegreeOfParallelism As Integer

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.

System_CAPS_noteNote

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

Return to top
Show: