ObjectRecommendationProperties interface
Object recommendation properties.
Properties
| analyzed |
Workload information for the recommended action. |
| current |
Current state. |
| details | Recommendation details for the recommended action. |
| estimated |
Estimated impact of this recommended action. |
| implementation |
Implementation details for the recommended action. |
| improved |
List of identifiers for all queries identified as targets for improvement if the recommendation is applied. The list is only populated for CREATE INDEX recommendations. |
| initial |
Creation time (UTC) of this recommendation. |
| last |
Last time (UTC) that this recommendation was produced. |
| recommendation |
Reason for this recommendation. |
| recommendation |
Type for this recommendation. |
| times |
Number of times this recommendation has been produced. |
Property Details
analyzedWorkload
Workload information for the recommended action.
analyzedWorkload?: ObjectRecommendationPropertiesAnalyzedWorkload
Property Value
currentState
Current state.
currentState?: string
Property Value
string
details
Recommendation details for the recommended action.
details?: ObjectRecommendationDetails
Property Value
estimatedImpact
Estimated impact of this recommended action.
estimatedImpact?: ImpactRecord[]
Property Value
implementationDetails
Implementation details for the recommended action.
implementationDetails?: ObjectRecommendationPropertiesImplementationDetails
Property Value
improvedQueryIds
List of identifiers for all queries identified as targets for improvement if the recommendation is applied. The list is only populated for CREATE INDEX recommendations.
improvedQueryIds?: number[]
Property Value
number[]
initialRecommendedTime
Creation time (UTC) of this recommendation.
initialRecommendedTime?: Date
Property Value
Date
lastRecommendedTime
Last time (UTC) that this recommendation was produced.
lastRecommendedTime?: Date
Property Value
Date
recommendationReason
Reason for this recommendation.
recommendationReason?: string
Property Value
string
recommendationType
Type for this recommendation.
recommendationType?: string
Property Value
string
timesRecommended
Number of times this recommendation has been produced.
timesRecommended?: number
Property Value
number