RecommendedIndex Class
- java.
lang. Object - ProxyResource
- com.
microsoft. azure. management. sql. RecommendedIndex
- com.
public class RecommendedIndex
Represents a database recommended index.
Method Summary
Modifier and Type | Method and Description |
---|---|
Recommended |
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'. |
List<String> |
columns()
Get columns over which to build index. |
DateTime |
created()
Get the UTC datetime showing when this resource was created (ISO8601 format). |
List<Operation |
estimatedImpact()
Get the estimated impact of doing recommended index action. |
List<String> |
includedColumns()
Get the list of column names to be included in the index. |
String |
indexScript()
Get the full build index script. |
Recommended |
indexType()
Get the type of index (CLUSTERED, NONCLUSTERED, COLUMNSTORE, CLUSTERED COLUMNSTORE). Possible values include: 'CLUSTERED', 'NONCLUSTERED', 'COLUMNSTORE', 'CLUSTERED COLUMNSTORE'. |
DateTime |
lastModified()
Get the UTC datetime of when was this resource last changed (ISO8601 format). |
List<Operation |
reportedImpact()
Get the values reported after index action is complete. |
String |
schema()
Get the schema where table to build index over resides. |
Recommended |
state()
Get the current recommendation state. Possible values include: 'Active', 'Pending', 'Executing', 'Verifying', 'Pending Revert', 'Reverting', 'Reverted', 'Ignored', 'Expired', 'Blocked', 'Success'. |
String |
table()
Get the table on which to build index. |
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:
columns
public List
Get columns over which to build index.
Returns:
created
public DateTime created()
Get the UTC datetime showing when this resource was created (ISO8601 format).
Returns:
estimatedImpact
public List
Get the estimated impact of doing recommended index action.
Returns:
includedColumns
public List
Get the list of column names to be included in the index.
Returns:
indexScript
public String indexScript()
Get the full build index script.
Returns:
indexType
public RecommendedIndexType indexType()
Get the type of index (CLUSTERED, NONCLUSTERED, COLUMNSTORE, CLUSTERED COLUMNSTORE). Possible values include: 'CLUSTERED', 'NONCLUSTERED', 'COLUMNSTORE', 'CLUSTERED COLUMNSTORE'.
Returns:
lastModified
public DateTime lastModified()
Get the UTC datetime of when was this resource last changed (ISO8601 format).
Returns:
reportedImpact
public List
Get the values reported after index action is complete.
Returns:
schema
public String schema()
Get the schema where table to build index over resides.
Returns:
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:
table
public String table()
Get the table on which to build index.
Returns:
Applies to
Azure SDK for Java