RecommendedIndex Class

Definition

Namespace:

Microsoft.Azure.Management.Sql.Fluent.Models

Assembly:

Microsoft.Azure.Management.Sql.Fluent.dll

Package:

Microsoft.Azure.Management.Sql.Fluent v1.38.1

Represents a database recommended index.

[Microsoft.Rest.Serialization.JsonTransformation]
public class RecommendedIndex : Microsoft.Azure.Management.Sql.Fluent.Models.ProxyResourceInner

[<Microsoft.Rest.Serialization.JsonTransformation>]
type RecommendedIndex = class
    inherit ProxyResourceInner

Public Class RecommendedIndex
Inherits ProxyResourceInner

Inheritance

Object

ProxyResource

Resource

ProxyResourceInner

RecommendedIndex

Attributes

JsonTransformationAttribute

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	Resource Id. Setter is protected because Id needs to be set in Network resources. (Inherited from ProxyResource)
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).
Location	Resource location (Inherited from Resource)
Name	Resource name (Inherited from ProxyResource)
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.
Tags	Resource tags (Inherited from Resource)
Type	Resource type (Inherited from ProxyResource)

Methods

Validate()

Validate the object. Throws ValidationException if validation fails. (Inherited from Resource)