RecommendedIndexProperties Class

Definition

Namespace:

Microsoft.Azure.Management.Sql.LegacySdk.Models

Assembly:

Microsoft.Azure.PowerShell.Cmdlets.Sql.LegacySdk.dll

Represents the properties of an Azure SQL Database recommended index.

public class RecommendedIndexProperties

type RecommendedIndexProperties = class

Public Class RecommendedIndexProperties

Inheritance

Object

RecommendedIndexProperties

Derived

Microsoft.Azure.Commands.Sql.Model.IndexRecommendation

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.