Condividi tramite


RecommendedIndex Class

Definition

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
Attributes

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