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() |
|