IndexRecommendation Class

Definition

Namespace:

Microsoft.Azure.Commands.Sql.Model

Assembly:

Microsoft.Azure.PowerShell.Cmdlets.Sql.dll

public class IndexRecommendation : Microsoft.Azure.Management.Sql.LegacySdk.Models.RecommendedIndexProperties

type IndexRecommendation = class
    inherit RecommendedIndexProperties

Public Class IndexRecommendation
Inherits RecommendedIndexProperties

Inheritance

Object

RecommendedIndexProperties

IndexRecommendation

Constructors

IndexRecommendation(RecommendedIndexProperties)

Copy constructor from base 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'. (Inherited from RecommendedIndexProperties)
Columns	Optional. Columns over which to build index (Inherited from RecommendedIndexProperties)
Created	Optional. Gets the UTC datetime showing when this resource was created. (Inherited from RecommendedIndexProperties)
DatabaseName	Azure SQL Database name on which this index should be created.
EstimatedImpact	Optional. Gets the estimated impact of doing recommended index action. (Inherited from RecommendedIndexProperties)
IncludedColumns	Optional. Gets the list of column names to be included in the index (Inherited from RecommendedIndexProperties)
IndexScript	Optional. Gets the full build index script (Inherited from RecommendedIndexProperties)
IndexType	Optional. Gets the type of index (CLUSTERED, NONCLUSTERED, COLUMNSTORE, CLUSTERED COLUMNSTORE) (Inherited from RecommendedIndexProperties)
LastModified	Optional. Gets the UTC datetime of when was this resource last changed. (Inherited from RecommendedIndexProperties)
Name	Name of recommended index.
ReportedImpact	Optional. Gets the values reported after index action is complete. (Inherited from RecommendedIndexProperties)
Schema	Optional. Gets the schema where table to build index over resides (Inherited from RecommendedIndexProperties)
State	Optional. Gets the state recommendation is in. Current options are: 'Active', 'Pending', 'Executing', 'Verifying', 'Pending Revert', 'Reverting', 'Reverted', 'Ignored', 'Expired', 'Blocked', 'Success'. (Inherited from RecommendedIndexProperties)
Table	Optional. Gets the table on which to build index. (Inherited from RecommendedIndexProperties)