RecommendedIndexProperties Class
Definition
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 the properties of an Azure SQL Database recommended index.
public class RecommendedIndexPropertiestype RecommendedIndexProperties = classPublic Class RecommendedIndexProperties- Inheritance
-
RecommendedIndexProperties
- Derived
Constructors
| RecommendedIndexProperties() |
Initializes a new instance of the RecommendedIndexProperties class. |
Properties
| Action |
Optional. Gets the proposed index action. We suggest user to create missing index, drop unused index or to rebuild already existing index to improve its performance. Possible values are 'Create', 'Drop', 'Rebuild'. |
| Columns |
Optional. Columns over which to build index |
| Created |
Optional. Gets the UTC datetime showing when this resource was created. |
| EstimatedImpact |
Optional. Gets the estimated impact of doing recommended index action. |
| IncludedColumns |
Optional. Gets the list of column names to be included in the index |
| IndexScript |
Optional. Gets the full build index script |
| IndexType |
Optional. Gets the type of index (CLUSTERED, NONCLUSTERED, COLUMNSTORE, CLUSTERED COLUMNSTORE) |
| LastModified |
Optional. Gets the UTC datetime of when was this resource last changed. |
| ReportedImpact |
Optional. Gets the values reported after index action is complete. |
| Schema |
Optional. Gets the schema where table to build index over resides |
| State |
Optional. Gets the state recommendation is in. Current options are: 'Active', 'Pending', 'Executing', 'Verifying', 'Pending Revert', 'Reverting', 'Reverted', 'Ignored', 'Expired', 'Blocked', 'Success'. |
| Table |
Optional. Gets the table on which to build index. |