Package com.microsoft.azure.management.sql

Class RecommendedIndex

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 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

    • 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

    • created

      public org.joda.time.DateTime created()
      Get the UTC datetime showing when this resource was created (ISO8601 format).
      Returns:
      the created value

    • lastModified

      public org.joda.time.DateTime lastModified()
      Get the UTC datetime of when was this resource last changed (ISO8601 format).
      Returns:
      the lastModified 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

    • schema

      public String schema()
      Get the schema where table to build index over resides.
      Returns:
      the schema value

    • table

      public String table()
      Get the table on which to build index.
      Returns:
      the table value

    • columns

      public List<String> columns()
      Get columns over which to build index.
      Returns:
      the columns value

    • includedColumns

      public List<String> 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

    • estimatedImpact

      public List<OperationImpact> estimatedImpact()
      Get the estimated impact of doing recommended index action.
      Returns:
      the estimatedImpact value

    • reportedImpact

      public List<OperationImpact> reportedImpact()
      Get the values reported after index action is complete.
      Returns:
      the reportedImpact value