Search

Class AzureRecommendedIndexProperties

Represents the properties of an Azure SQL Database recommended index.

Attributes

Name Type Description
action String 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 Object[] Optional. Columns over which to build index
created Date Optional. Gets the UTC datetime showing when this resource was created.
estimatedImpact Object[] Optional. Gets the estimated impact of doing recommended index action.
includedColumns Object[] Optional. Gets the list of column names to be included in the index
indexScript String Optional. Gets the full build index script
indexType String Optional. Gets the type of index (CLUSTERED, NONCLUSTERED, COLUMNSTORE, CLUSTERED COLUMNSTORE)
lastModified Date Optional. Gets the UTC datetime of when was this resource last changed.
reportedImpact Object[] Optional. Gets the values reported after index action is complete.
schema String Optional. Gets the schema where table to build index over resides
state String Optional. Gets the state recommendation is in. Current options are: 'Active', 'Pending', 'Executing', 'Verifying', 'Pending Revert', 'Reverting', 'Reverted', 'Ignored', 'Expired', 'Blocked', 'Success'.
table String Optional. Gets the table on which to build index.

Methods

Name Returns
AzureRecommendedIndexProperties() constructor

Returned by

None

Referenced in

None