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.
Examples
Creating, Altering, and Removing Indexes
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace