RecommendedIndex Class

Definition

Represents a database recommended index.

[Microsoft.Rest.Serialization.JsonTransformation]
public class RecommendedIndex : Microsoft.Azure.Management.Sql.Models.ProxyResource
type RecommendedIndex = class
    inherit ProxyResource
Public Class RecommendedIndex
Inherits ProxyResource
Inheritance
RecommendedIndex
Attributes

Constructors

RecommendedIndex()

Initializes a new instance of the RecommendedIndex class.

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>)

Initializes a new instance of the RecommendedIndex class.

Properties

Action

Gets the proposed index action. You can create a missing index, drop an unused index, or rebuild an existing index to improve its performance. Possible values include: 'Create', 'Drop', 'Rebuild'

Columns

Gets columns over which to build index

Created

Gets the UTC datetime showing when this resource was created (ISO8601 format).

EstimatedImpact

Gets the estimated impact of doing recommended index action.

Id

Gets resource ID.

(Inherited from Resource)
IncludedColumns

Gets the list of column names to be included in the index

IndexScript

Gets the full build index script

IndexType

Gets the type of index (CLUSTERED, NONCLUSTERED, COLUMNSTORE, CLUSTERED COLUMNSTORE). Possible values include: 'CLUSTERED', 'NONCLUSTERED', 'COLUMNSTORE', 'CLUSTERED COLUMNSTORE'

LastModified

Gets the UTC datetime of when was this resource last changed (ISO8601 format).

Name

Gets resource name.

(Inherited from Resource)
ReportedImpact

Gets the values reported after index action is complete.

Schema

Gets the schema where table to build index over resides

State

Gets the current recommendation state. Possible values include: 'Active', 'Pending', 'Executing', 'Verifying', 'Pending Revert', 'Reverting', 'Reverted', 'Ignored', 'Expired', 'Blocked', 'Success'

Table

Gets the table on which to build index.

Type

Gets resource type.

(Inherited from Resource)

Applies to