ObjectRecommendationProperties interface

Object recommendation properties.

Properties

analyzedWorkload

Workload information for the recommended action.

currentState

Current state.

details

Recommendation details for the recommended action.

estimatedImpact

Estimated impact of this recommended action.

implementationDetails

Implementation details for the recommended action.

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.

initialRecommendedTime

Creation time (UTC) of this recommendation.

lastRecommendedTime

Last time (UTC) that this recommendation was produced.

recommendationReason

Reason for this recommendation.

recommendationType

Type for this recommendation.

timesRecommended

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