SqlTuningAdvisorTaskSummaryReportIndexFindingSummary¶

class oci.database_management.models.SqlTuningAdvisorTaskSummaryReportIndexFindingSummary(**kwargs)¶

Bases: object

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

Methods

__init__(**kwargs) Initializes a new SqlTuningAdvisorTaskSummaryReportIndexFindingSummary object with values from keyword arguments.

Attributes

`index_columns`	[Required] Gets the index_columns of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary.
`index_hash_value`	[Required] Gets the index_hash_value of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary.
`index_name`	[Required] Gets the index_name of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary.
`reference_count`	[Required] Gets the reference_count of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary.
`schema`	[Required] Gets the schema of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary.
`table_name`	[Required] Gets the table_name of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary.

__init__(**kwargs)¶

Initializes a new SqlTuningAdvisorTaskSummaryReportIndexFindingSummary object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:

index_hash_value (int) – The value to assign to the index_hash_value property of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary.
index_name (str) – The value to assign to the index_name property of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary.
table_name (str) – The value to assign to the table_name property of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary.
schema (str) – The value to assign to the schema property of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary.
reference_count (int) – The value to assign to the reference_count property of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary.
index_columns (list[str]) – The value to assign to the index_columns property of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary.

index_columns¶

[Required] Gets the index_columns of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary. Columns of the index.

Returns:	The index_columns of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary.
Return type:	list[str]

index_hash_value¶

[Required] Gets the index_hash_value of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary. Numerical representation of the index.

Returns:	The index_hash_value of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary.
Return type:	int

index_name¶

[Required] Gets the index_name of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary. Name of the index.

Returns:	The index_name of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary.
Return type:	str

reference_count¶

[Required] Gets the reference_count of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary. The number of times the index is referenced within the SQL Tuning advisor task findings.

Returns:	The reference_count of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary.
Return type:	int

schema¶

[Required] Gets the schema of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary. Schema related to the index.

Returns:	The schema of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary.
Return type:	str

table_name¶

[Required] Gets the table_name of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary. Table’s name related to the index.

Returns:	The table_name of this SqlTuningAdvisorTaskSummaryReportIndexFindingSummary.
Return type:	str