• Article

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)

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property MaximumDegreeOfParallelism As Integer
    Get
    Set
'Usage
Dim instance As Index
Dim value As Integer

value = instance.MaximumDegreeOfParallelism

instance.MaximumDegreeOfParallelism = value

[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public int MaximumDegreeOfParallelism { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property int MaximumDegreeOfParallelism {
    int get ();
    void set (int value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member MaximumDegreeOfParallelism : int with get, set

function get MaximumDegreeOfParallelism () : int
function set MaximumDegreeOfParallelism (value : int)

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.

Remarks

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

Note

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