Class SqlTuningAdvisorTaskRecommendationSummary

A recommendation for a given object in a SQL Tuning Task.

Inheritance
object
SqlTuningAdvisorTaskRecommendationSummary
Inherited Members
Namespace: Oci.DatabasemanagementService.Models
Assembly: OCI.DotNetSDK.Databasemanagement.dll
Syntax
public class SqlTuningAdvisorTaskRecommendationSummary

Properties

Benefit

Declaration
[JsonProperty(PropertyName = "benefit")]
public float? Benefit { get; set; }
Property Value
Type Description
float?

The percentage benefit of this implementation.

Finding

Declaration
[JsonProperty(PropertyName = "finding")]
public string Finding { get; set; }
Property Value
Type Description
string

Summary of the issue found in the SQL statement.

ImplementActionSql

Declaration
[JsonProperty(PropertyName = "implementActionSql")]
public string ImplementActionSql { get; set; }
Property Value
Type Description
string

Action sql to be implemented based on the recommendation result.

IsParallelExecution

Declaration
[JsonProperty(PropertyName = "isParallelExecution")]
public bool? IsParallelExecution { get; set; }
Property Value
Type Description
bool?

Indicates whether a SQL Profile recommendation uses parallel execution.

Rationale

Declaration
[JsonProperty(PropertyName = "rationale")]
public string Rationale { get; set; }
Property Value
Type Description
string

Describes the reasoning behind the recommendation and how it relates to the finding.

Recommendation

Declaration
[JsonProperty(PropertyName = "recommendation")]
public string Recommendation { get; set; }
Property Value
Type Description
string

The recommendation for a specific finding.

RecommendationKey

Declaration
[Required(ErrorMessage = "RecommendationKey is required.")]
[JsonProperty(PropertyName = "recommendationKey")]
public int? RecommendationKey { get; set; }
Property Value
Type Description
int?

The unique identifier of the recommendation in the scope of the task.
Remarks

Required

RecommendationType

Declaration
[Required(ErrorMessage = "RecommendationType is required.")]
[JsonProperty(PropertyName = "recommendationType")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlTuningAdvisorTaskRecommendationSummary.RecommendationTypeEnum? RecommendationType { get; set; }
Property Value
Type Description
SqlTuningAdvisorTaskRecommendationSummary.RecommendationTypeEnum?

Type of recommendation.
Remarks

Required

SqlTuningAdvisorTaskId

Declaration
[Required(ErrorMessage = "SqlTuningAdvisorTaskId is required.")]
[JsonProperty(PropertyName = "sqlTuningAdvisorTaskId")]
public long? SqlTuningAdvisorTaskId { get; set; }
Property Value
Type Description
long?

The unique identifier of the task. This is not the OCID.
Remarks

Required

SqlTuningAdvisorTaskObjectId

Declaration
[Required(ErrorMessage = "SqlTuningAdvisorTaskObjectId is required.")]
[JsonProperty(PropertyName = "sqlTuningAdvisorTaskObjectId")]
public long? SqlTuningAdvisorTaskObjectId { get; set; }
Property Value
Type Description
long?

The key of the object to which these recommendations apply. This is not the OCID.
Remarks

Required