你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站,请访问 https://docs.azure.cn

RecommendedIndex 构造函数

定义

重载

RecommendedIndex()

初始化 RecommendedIndex 类的新实例。

RecommendedIndex(String, String, String, Nullable<RecommendedIndexAction>, Nullable<RecommendedIndexState>, Nullable<DateTime>, Nullable<DateTime>, Nullable<RecommendedIndexType>, String, String, IList<String>, IList<String>, String, IList<OperationImpact>, IList<OperationImpact>)

初始化 RecommendedIndex 类的新实例。

RecommendedIndex()

初始化 RecommendedIndex 类的新实例。

public RecommendedIndex ();
Public Sub New ()

适用于

RecommendedIndex(String, String, String, Nullable<RecommendedIndexAction>, Nullable<RecommendedIndexState>, Nullable<DateTime>, Nullable<DateTime>, Nullable<RecommendedIndexType>, String, String, IList<String>, IList<String>, String, IList<OperationImpact>, IList<OperationImpact>)

初始化 RecommendedIndex 类的新实例。

public RecommendedIndex (string id = default, string name = default, string type = default, Microsoft.Azure.Management.Sql.Fluent.Models.RecommendedIndexAction? action = default, Microsoft.Azure.Management.Sql.Fluent.Models.RecommendedIndexState? state = default, DateTime? created = default, DateTime? lastModified = default, Microsoft.Azure.Management.Sql.Fluent.Models.RecommendedIndexType? indexType = default, string schema = default, string table = default, System.Collections.Generic.IList<string> columns = default, System.Collections.Generic.IList<string> includedColumns = default, string indexScript = default, System.Collections.Generic.IList<Microsoft.Azure.Management.Sql.Fluent.Models.OperationImpact> estimatedImpact = default, System.Collections.Generic.IList<Microsoft.Azure.Management.Sql.Fluent.Models.OperationImpact> reportedImpact = default);
new Microsoft.Azure.Management.Sql.Fluent.Models.RecommendedIndex : string * string * string * Nullable<Microsoft.Azure.Management.Sql.Fluent.Models.RecommendedIndexAction> * Nullable<Microsoft.Azure.Management.Sql.Fluent.Models.RecommendedIndexState> * Nullable<DateTime> * Nullable<DateTime> * Nullable<Microsoft.Azure.Management.Sql.Fluent.Models.RecommendedIndexType> * string * string * System.Collections.Generic.IList<string> * System.Collections.Generic.IList<string> * string * System.Collections.Generic.IList<Microsoft.Azure.Management.Sql.Fluent.Models.OperationImpact> * System.Collections.Generic.IList<Microsoft.Azure.Management.Sql.Fluent.Models.OperationImpact> -> Microsoft.Azure.Management.Sql.Fluent.Models.RecommendedIndex
Public Sub New (Optional id As String = Nothing, Optional name As String = Nothing, Optional type As String = Nothing, Optional action As Nullable(Of RecommendedIndexAction) = Nothing, Optional state As Nullable(Of RecommendedIndexState) = Nothing, Optional created As Nullable(Of DateTime) = Nothing, Optional lastModified As Nullable(Of DateTime) = Nothing, Optional indexType As Nullable(Of RecommendedIndexType) = Nothing, Optional schema As String = Nothing, Optional table As String = Nothing, Optional columns As IList(Of String) = Nothing, Optional includedColumns As IList(Of String) = Nothing, Optional indexScript As String = Nothing, Optional estimatedImpact As IList(Of OperationImpact) = Nothing, Optional reportedImpact As IList(Of OperationImpact) = Nothing)

参数

id
String
name
String
type
String
action
Nullable<RecommendedIndexAction>

建议的索引操作。 可以创建缺失的索引、删除未使用的索引或重新生成现有索引以提高其性能。 可能的值包括:“Create”、“Drop”、“Rebuild”

state
Nullable<RecommendedIndexState>

当前建议状态。 可能的值包括:“Active”、“Pending”、“Executing”、“Verifying”、“Pending Revert”、“Reverting”、“Reverted”、“Ignored”、“Expired”、“Blocked”、“Success”

created
Nullable<DateTime>

显示此资源的创建时间的 UTC 日期时间 (ISO8601 格式) 。

lastModified
Nullable<DateTime>

此资源上次更改的 UTC 日期时间 (ISO8601 格式) 。

indexType
Nullable<RecommendedIndexType>

索引的类型 (CLUSTERED、NONCLUSTERED、COLUMNSTORE、CLUSTERED COLUMNSTORE) 。 可能的值包括:“CLUSTERED”、“NONCLUSTERED”、“COLUMNSTORE”、“CLUSTERED COLUMNSTORE”

schema
String

要在其上生成索引的表所在的架构

table
String

要基于其生成索引的表。

columns
IList<String>

要基于其生成索引的列

includedColumns
IList<String>

要包含在索引中的列名列表

indexScript
String

完整的生成索引脚本

estimatedImpact
IList<OperationImpact>

执行建议的索引操作的估计影响。

reportedImpact
IList<OperationImpact>

索引操作完成后报告的值。

适用于