Proprietà Index.MaximumDegreeOfParallelism

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

Spazio dei nomi  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property MaximumDegreeOfParallelism As Integer 
    Get 
    Set
'Utilizzo
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)

Valore proprietà

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

Osservazioni

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

[!NOTA]

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

Esempi

Creazione, modifica e rimozione di indici

Vedere anche

Riferimento

Index Classe

Spazio dei nomi Microsoft.SqlServer.Management.Smo

Altre risorse

Indici

CREATE INDEX (Transact-SQL)