IRecommendedIndexOperations.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 System.Threading.Tasks.Task<Microsoft.Azure.Management.Sql.LegacySdk.Models.RecommendedIndexUpdateResponse> UpdateAsync (string resourceGroupName, string serverName, string databaseName, string schemaName, string tableName, string indexName, Microsoft.Azure.Management.Sql.LegacySdk.Models.RecommendedIndexUpdateParameters parameters, System.Threading.CancellationToken cancellationToken);

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

Public Function UpdateAsync (resourceGroupName As String, serverName As String, databaseName As String, schemaName As String, tableName As String, indexName As String, parameters As RecommendedIndexUpdateParameters, cancellationToken As CancellationToken) As Task(Of RecommendedIndexUpdateResponse)

Parameters

resourceGroupName

String

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

serverName

String

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

databaseName

String

The name of the Azure SQL Database.

schemaName

String

The name of the Azure SQL Database schema.

tableName

String

The name of the Azure SQL Database table.

indexName

String

The name of the Azure SQL Database recommended index.

parameters

RecommendedIndexUpdateParameters

The required parameters for updating index state.

cancellationToken

CancellationToken

Cancellation token.

Returns

Task<RecommendedIndexUpdateResponse>

Represents the response to a get recommended index request.