Package | Description |
---|---|
com.oracle.bmc.databasemanagement.model |
Modifier and Type | Method and Description |
---|---|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.accessPredicates(String accessPredicates)
The predicates used to locate rows in an access structure.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.attribute(String attribute)
The text string identifying the type of execution plan.
|
static SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.builder()
Create a new builder.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.bytes(Long bytes)
The number of bytes returned by the current operation.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.cardinality(Long cardinality)
The number of rows returned by the current operation (estimated by the CBO).
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.copy(SqlTuningTaskSqlExecutionPlanStep model) |
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.cost(Double cost)
The cost of the current operation estimated by the cost-based optimizer (CBO).
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.cpuCost(Double cpuCost)
The CPU cost of the current operation.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.filterPredicates(String filterPredicates)
The predicates used to filter rows before producing them.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.ioCost(Double ioCost)
The I/O cost of the current operation.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.numberOfSearchColumn(Integer numberOfSearchColumn)
Number of index columns with start and stop keys (that is, the number of columns with
matching predicates).
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.objectName(String objectName)
The name of the object.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.objectNode(String objectNode)
The name of the database link used to reference the object.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.objectOwner(String objectOwner)
The owner of the object.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.objectPosition(Integer objectPosition)
The numbered position of the object name in the original SQL statement.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.objectType(String objectType)
The descriptive modifier that further describes the type of object.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.operation(String operation)
The name of the operation performed at this step.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.optimizerMode(String optimizerMode)
The current mode of the optimizer, such as all_rows, first_rows_n (where n = 1, 10, 100,
1000, and so on).
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.options(String options)
The options used for the operation performed at this step.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.other(String other)
Information about parallel execution servers and parallel queries
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.otherTag(String otherTag)
Describes the function of the SQL text in the OTHER column.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.parentStepId(Integer parentStepId)
The ID of the next step that operates on the results of this step.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.partitionId(Integer partitionId)
The ID of the step in the execution plan that has computed the pair of values of
partitionStart and partitionStop.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.partitionStart(String partitionStart)
A step may get data from a range of partitions of a partitioned object, such as table or
index, based on predicates and sorting order.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.partitionStop(String partitionStop)
A step may get data from a range of partitions of a partitioned object, such as table or
index, based on predicates and sorting order.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.planHashValue(Long planHashValue)
The numerical representation of the SQL execution plan.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.position(Integer position)
The order of processing for steps with the same parent ID.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.remarks(String remarks)
The place for comments that can be added to the steps of the execution plan.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.stepId(Integer stepId)
The identification number of a step in the SQL execution plan.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.tempSpace(Long tempSpace)
The temporary space usage (in bytes) of the operation (sort or hash-join) as estimated by
the CBO.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.Builder.time(Long time)
The elapsed time (in seconds) of the operation as estimated by the CBO.
|
SqlTuningTaskSqlExecutionPlanStep.Builder |
SqlTuningTaskSqlExecutionPlanStep.toBuilder() |
Copyright © 2016–2024. All rights reserved.