RecommendedIndexOperationsExtensions Class

Definition

The Windows Azure SQL Database management API provides a RESTful set of web services that interact with Windows Azure SQL Database services to manage your databases. The API enables users to create, retrieve, update, and delete databases and servers.

public static class RecommendedIndexOperationsExtensions
type RecommendedIndexOperationsExtensions = class
Public Module RecommendedIndexOperationsExtensions
Inheritance
RecommendedIndexOperationsExtensions

Methods

Get(IRecommendedIndexOperations, String, String, String, String, String, String)

Returns details on recommended index.

GetAsync(IRecommendedIndexOperations, String, String, String, String, String, String)

Returns details on recommended index.

Update(IRecommendedIndexOperations, String, String, String, String, String, String, RecommendedIndexUpdateParameters)

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
UpdateAsync(IRecommendedIndexOperations, String, String, String, String, String, String, RecommendedIndexUpdateParameters)

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

Applies to