RecommendedIndex Class

  • Reference
Package:
com.microsoft.azure.management.sql
Maven Artifact:
com.microsoft.azure:azure-mgmt-sql:1.41.4
  • java.lang.Object
    • com.microsoft.azure.ProxyResource
      • com.microsoft.azure.management.sql.RecommendedIndex

public class RecommendedIndex
extends com.microsoft.azure.ProxyResource

Represents a database recommended index.

Constructor Summary

Constructor Description
RecommendedIndex()

Method Summary

Modifier and Type Method and Description
RecommendedIndexAction action()

Get the proposed index action.
java.util.List<java.lang.String> columns()

Get columns over which to build index.
org.joda.time.DateTime created()

Get the UTC datetime showing when this resource was created (ISO8601 format).
java.util.List<OperationImpact> estimatedImpact()

Get the estimated impact of doing recommended index action.
java.util.List<java.lang.String> includedColumns()

Get the list of column names to be included in the index.
java.lang.String indexScript()

Get the full build index script.
RecommendedIndexType indexType()

Get the type of index (CLUSTERED, NONCLUSTERED, COLUMNSTORE, CLUSTERED COLUMNSTORE).
org.joda.time.DateTime lastModified()

Get the UTC datetime of when was this resource last changed (ISO8601 format).
java.util.List<OperationImpact> reportedImpact()

Get the values reported after index action is complete.
java.lang.String schema()

Get the schema where table to build index over resides.
RecommendedIndexState state()

Get the current recommendation state.
java.lang.String table()

Get the table on which to build index.

Methods inherited from com.microsoft.azure.ProxyResource

com.microsoft.azure.ProxyResource.id com.microsoft.azure.ProxyResource.name com.microsoft.azure.ProxyResource.type

Methods inherited from java.lang.Object

java.lang.Object.clone java.lang.Object.equals java.lang.Object.finalize java.lang.Object.getClass java.lang.Object.hashCode java.lang.Object.notify java.lang.Object.notifyAll java.lang.Object.toString java.lang.Object.wait java.lang.Object.wait java.lang.Object.wait

Constructor Details

RecommendedIndex

public RecommendedIndex()

Method Details

action

public RecommendedIndexAction action()

Get 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'.

Returns:

the action value

columns

public List columns()

Get columns over which to build index.

Returns:

the columns value

created

public DateTime created()

Get the UTC datetime showing when this resource was created (ISO8601 format).

Returns:

the created value

estimatedImpact

public List estimatedImpact()

Get the estimated impact of doing recommended index action.

Returns:

the estimatedImpact value

includedColumns

public List includedColumns()

Get the list of column names to be included in the index.

Returns:

the includedColumns value

indexScript

public String indexScript()

Get the full build index script.

Returns:

the indexScript value

indexType

public RecommendedIndexType indexType()

Get the type of index (CLUSTERED, NONCLUSTERED, COLUMNSTORE, CLUSTERED COLUMNSTORE). Possible values include: 'CLUSTERED', 'NONCLUSTERED', 'COLUMNSTORE', 'CLUSTERED COLUMNSTORE'.

Returns:

the indexType value

lastModified

public DateTime lastModified()

Get the UTC datetime of when was this resource last changed (ISO8601 format).

Returns:

the lastModified value

reportedImpact

public List reportedImpact()

Get the values reported after index action is complete.

Returns:

the reportedImpact value

schema

public String schema()

Get the schema where table to build index over resides.

Returns:

the schema value

state

public RecommendedIndexState state()

Get the current recommendation state. Possible values include: 'Active', 'Pending', 'Executing', 'Verifying', 'Pending Revert', 'Reverting', 'Reverted', 'Ignored', 'Expired', 'Blocked', 'Success'.

Returns:

the state value

table

public String table()

Get the table on which to build index.

Returns:

the table value

Applies to