RecommendedIndexOperationsExtensions.UpdateAsync Method

Definition

Namespace:

Microsoft.Azure.Management.Sql.LegacySdk

Assembly:

Microsoft.Azure.PowerShell.Cmdlets.Sql.LegacySdk.dll

We execute or cancel index operations by updating index state. Allowed state transitions are :Active -> Pending

• Start index creation processPending -> Active
• Cancel index creationActive/Pending -> Ignored
• Ignore index recommendation so it will no longer show in active recommendationsIgnored -> Active - Restore index recommendationSuccess -> Pending Revert - Revert index that has been createdPending Revert -> Revert Canceled - Cancel index revert operation

public static System.Threading.Tasks.Task<Microsoft.Azure.Management.Sql.LegacySdk.Models.RecommendedIndexUpdateResponse> UpdateAsync (this Microsoft.Azure.Management.Sql.LegacySdk.IRecommendedIndexOperations operations, string resourceGroupName, string serverName, string databaseName, string schemaName, string tableName, string indexName, Microsoft.Azure.Management.Sql.LegacySdk.Models.RecommendedIndexUpdateParameters parameters);

static member UpdateAsync : Microsoft.Azure.Management.Sql.LegacySdk.IRecommendedIndexOperations * string * string * string * string * string * string * Microsoft.Azure.Management.Sql.LegacySdk.Models.RecommendedIndexUpdateParameters -> System.Threading.Tasks.Task<Microsoft.Azure.Management.Sql.LegacySdk.Models.RecommendedIndexUpdateResponse>

<Extension()>
Public Function UpdateAsync (operations As IRecommendedIndexOperations, resourceGroupName As String, serverName As String, databaseName As String, schemaName As String, tableName As String, indexName As String, parameters As RecommendedIndexUpdateParameters) As Task(Of RecommendedIndexUpdateResponse)

Parameters

operations

IRecommendedIndexOperations

Reference to the Microsoft.Azure.Management.Sql.LegacySdk.IRecommendedIndexOperations.

resourceGroupName

String

Required. The name of the Resource Group to which the Azure SQL Database Server belongs.

serverName

String

Required. The name of the Azure SQL Database Server on which the database is hosted.

databaseName

String

Required. The name of the Azure SQL Database.

schemaName

String

Required. The name of the Azure SQL Database schema.

tableName

String

Required. The name of the Azure SQL Database table.

indexName

String

Required. The name of the Azure SQL Database recommended index.

parameters

RecommendedIndexUpdateParameters

Required. The required parameters for updating index state.

Returns

Task<RecommendedIndexUpdateResponse>

Represents the response to a get recommended index request.