通过

Index.MaximumDegreeOfParallelism 属性

  • 项目

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

命名空间：  Microsoft.SqlServer.Management.Smo
程序集：  Microsoft.SqlServer.Smo（在 Microsoft.SqlServer.Smo.dll 中）

语法

声明
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property MaximumDegreeOfParallelism As Integer 
    Get 
    Set
用法
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)

属性值

类型：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.

注意注意

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

示例

创建、更改和删除索引

请参阅

参考

Index 类

Microsoft.SqlServer.Management.Smo 命名空间

其他资源

索引

CREATE INDEX (Transact-SQL)