Class SqlTuningAdvisorTaskSummaryReportIndexFindingSummary
A summary for all the index findings in a SQL Tuning Advisor task. Includes the index's hash value, table name, schema, index name, reference count and index columns
Inherited Members
Namespace: Oci.DatabasemanagementService.Models
Assembly: OCI.DotNetSDK.Databasemanagement.dll
Syntax
public class SqlTuningAdvisorTaskSummaryReportIndexFindingSummary
Properties
IndexColumns
Declaration
[Required(ErrorMessage = "IndexColumns is required.")]
[JsonProperty(PropertyName = "indexColumns")]
public List<string> IndexColumns { get; set; }
Property Value
Type | Description |
---|---|
List<string> | Columns of the index. |
Remarks
Required
IndexHashValue
Declaration
[Required(ErrorMessage = "IndexHashValue is required.")]
[JsonProperty(PropertyName = "indexHashValue")]
public long? IndexHashValue { get; set; }
Property Value
Type | Description |
---|---|
long? | Numerical representation of the index. |
Remarks
Required
IndexName
Declaration
[Required(ErrorMessage = "IndexName is required.")]
[JsonProperty(PropertyName = "indexName")]
public string IndexName { get; set; }
Property Value
Type | Description |
---|---|
string | Name of the index. |
Remarks
Required
ReferenceCount
Declaration
[Required(ErrorMessage = "ReferenceCount is required.")]
[JsonProperty(PropertyName = "referenceCount")]
public int? ReferenceCount { get; set; }
Property Value
Type | Description |
---|---|
int? | The number of times the index is referenced within the SQL Tuning advisor task findings. |
Remarks
Required
Schema
Declaration
[Required(ErrorMessage = "Schema is required.")]
[JsonProperty(PropertyName = "schema")]
public string Schema { get; set; }
Property Value
Type | Description |
---|---|
string | Schema related to the index. |
Remarks
Required
TableName
Declaration
[Required(ErrorMessage = "TableName is required.")]
[JsonProperty(PropertyName = "tableName")]
public string TableName { get; set; }
Property Value
Type | Description |
---|---|
string | Table's name related to the index. |
Remarks
Required