RecommendedIndex Class

Reference

Definition

Namespace:: Microsoft.Azure.Management.Sql.Fluent.Models

Assembly:: Microsoft.Azure.Management.Sql.Fluent.dll

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

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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)

Applies to

Condividi tramite