IndexRecommendation 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.
public class IndexRecommendation : Microsoft.Azure.Management.Sql.LegacySdk.Models.RecommendedIndexPropertiestype IndexRecommendation = class
inherit RecommendedIndexPropertiesPublic Class IndexRecommendation
Inherits RecommendedIndexProperties- Inheritance
Constructors
| IndexRecommendation(RecommendedIndexProperties) |
Copy constructor from base 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'. (Inherited from RecommendedIndexProperties) |
| Columns |
Optional. Columns over which to build index (Inherited from RecommendedIndexProperties) |
| Created |
Optional. Gets the UTC datetime showing when this resource was created. (Inherited from RecommendedIndexProperties) |
| DatabaseName |
Azure SQL Database name on which this index should be created. |
| EstimatedImpact |
Optional. Gets the estimated impact of doing recommended index action. (Inherited from RecommendedIndexProperties) |
| IncludedColumns |
Optional. Gets the list of column names to be included in the index (Inherited from RecommendedIndexProperties) |
| IndexScript |
Optional. Gets the full build index script (Inherited from RecommendedIndexProperties) |
| IndexType |
Optional. Gets the type of index (CLUSTERED, NONCLUSTERED, COLUMNSTORE, CLUSTERED COLUMNSTORE) (Inherited from RecommendedIndexProperties) |
| LastModified |
Optional. Gets the UTC datetime of when was this resource last changed. (Inherited from RecommendedIndexProperties) |
| Name |
Name of recommended index. |
| ReportedImpact |
Optional. Gets the values reported after index action is complete. (Inherited from RecommendedIndexProperties) |
| Schema |
Optional. Gets the schema where table to build index over resides (Inherited from RecommendedIndexProperties) |
| State |
Optional. Gets the state recommendation is in. Current options are: 'Active', 'Pending', 'Executing', 'Verifying', 'Pending Revert', 'Reverting', 'Reverted', 'Ignored', 'Expired', 'Blocked', 'Success'. (Inherited from RecommendedIndexProperties) |
| Table |
Optional. Gets the table on which to build index. (Inherited from RecommendedIndexProperties) |