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
-