Partilhar via


RecommendedIndexProperties Class

Definition

Represents the properties of an Azure SQL Database recommended index.

public class RecommendedIndexProperties
type RecommendedIndexProperties = class
Public Class RecommendedIndexProperties
Inheritance
RecommendedIndexProperties
Derived

Constructors

RecommendedIndexProperties()

Initializes a new instance of the RecommendedIndexProperties class.

Properties

Action

Optional. Gets the proposed index action. We suggest user to create missing index, drop unused index or to rebuild already existing index to improve its performance. Possible values are 'Create', 'Drop', 'Rebuild'.

Columns

Optional. Columns over which to build index

Created

Optional. Gets the UTC datetime showing when this resource was created.

EstimatedImpact

Optional. Gets the estimated impact of doing recommended index action.

IncludedColumns

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

IndexScript

Optional. Gets the full build index script

IndexType

Optional. Gets the type of index (CLUSTERED, NONCLUSTERED, COLUMNSTORE, CLUSTERED COLUMNSTORE)

LastModified

Optional. Gets the UTC datetime of when was this resource last changed.

ReportedImpact

Optional. Gets the values reported after index action is complete.

Schema

Optional. Gets the schema where table to build index over resides

State

Optional. Gets the state recommendation is in. Current options are: 'Active', 'Pending', 'Executing', 'Verifying', 'Pending Revert', 'Reverting', 'Reverted', 'Ignored', 'Expired', 'Blocked', 'Success'.

Table

Optional. Gets the table on which to build index.

Applies to