Class SqlTuningAdvisorTaskSummaryFindingCounts

The number of findings in the SQL Tuning Advisor summary report.

Inheritance

object

SqlTuningAdvisorTaskSummaryFindingCounts

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Oci.DatabasemanagementService.Models

Assembly: OCI.DotNetSDK.Databasemanagement.dll

Syntax

public class SqlTuningAdvisorTaskSummaryFindingCounts

Properties

AlternatePlan

Declaration

[Required(ErrorMessage = "AlternatePlan is required.")]
[JsonProperty(PropertyName = "alternatePlan")]
public int? AlternatePlan { get; set; }

Property Value

Type	Description
int?	The number of distinct SQL statements with alternative plan recommendations.

Remarks

Required

ImplementedSqlProfile

Declaration

[Required(ErrorMessage = "ImplementedSqlProfile is required.")]
[JsonProperty(PropertyName = "implementedSqlProfile")]
public int? ImplementedSqlProfile { get; set; }

Property Value

Type	Description
int?	The number of distinct SQL statements with implemented SQL profiles.

Remarks

Required

Index

Declaration

[Required(ErrorMessage = "Index is required.")]
[JsonProperty(PropertyName = "index")]
public int? Index { get; set; }

Property Value

Type	Description
int?	The number of distinct SQL statements with index recommendations.

Remarks

Required

RecommendedSqlProfile

Declaration

[Required(ErrorMessage = "RecommendedSqlProfile is required.")]
[JsonProperty(PropertyName = "recommendedSqlProfile")]
public int? RecommendedSqlProfile { get; set; }

Property Value

Type	Description
int?	The number of distinct SQL statements with recommended SQL profiles.

Remarks

Required

Restructure

Declaration

[Required(ErrorMessage = "Restructure is required.")]
[JsonProperty(PropertyName = "restructure")]
public int? Restructure { get; set; }

Property Value

Type	Description
int?	The number of distinct SQL statements with restructured SQL recommendations.

Remarks

Required

Statistics

Declaration

[Required(ErrorMessage = "Statistics is required.")]
[JsonProperty(PropertyName = "statistics")]
public int? Statistics { get; set; }

Property Value

Type	Description
int?	The number of distinct SQL statements with stale or missing optimizer statistics recommendations.

Remarks

Required