SqlTuningTaskSqlExecutionPlanStep.Builder (Oracle Cloud Infrastructure Java SDK

java.lang.Object
- com.oracle.bmc.databasemanagement.model.SqlTuningTaskSqlExecutionPlanStep.Builder

Enclosing class:: SqlTuningTaskSqlExecutionPlanStep

public static class SqlTuningTaskSqlExecutionPlanStep.Builder
extends Object

Constructor Summary

Constructors
Constructor and Description

Builder()

Constructors
Constructor and Description
`Builder()`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`SqlTuningTaskSqlExecutionPlanStep.Builder`	`accessPredicates(String accessPredicates)` The predicates used to locate rows in an access structure.
`SqlTuningTaskSqlExecutionPlanStep.Builder`	`attribute(String attribute)` The text string identifying the type of execution plan.
`SqlTuningTaskSqlExecutionPlanStep`	`build()`
`SqlTuningTaskSqlExecutionPlanStep.Builder`	`bytes(Long bytes)` The number of bytes returned by the current operation.
`SqlTuningTaskSqlExecutionPlanStep.Builder`	`cardinality(Long cardinality)` The number of rows returned by the current operation (estimated by the CBO).
`SqlTuningTaskSqlExecutionPlanStep.Builder`	`copy(SqlTuningTaskSqlExecutionPlanStep model)`
`SqlTuningTaskSqlExecutionPlanStep.Builder`	`cost(Double cost)` The cost of the current operation estimated by the cost-based optimizer (CBO).
`SqlTuningTaskSqlExecutionPlanStep.Builder`	`cpuCost(Double cpuCost)` The CPU cost of the current operation.
`SqlTuningTaskSqlExecutionPlanStep.Builder`	`filterPredicates(String filterPredicates)` The predicates used to filter rows before producing them.
`SqlTuningTaskSqlExecutionPlanStep.Builder`	`ioCost(Double ioCost)` The I/O cost of the current operation.
`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`	`objectName(String objectName)` The name of the object.
`SqlTuningTaskSqlExecutionPlanStep.Builder`	`objectNode(String objectNode)` The name of the database link used to reference the object.
`SqlTuningTaskSqlExecutionPlanStep.Builder`	`objectOwner(String objectOwner)` The owner of the object.
`SqlTuningTaskSqlExecutionPlanStep.Builder`	`objectPosition(Integer objectPosition)` The numbered position of the object name in the original SQL statement.
`SqlTuningTaskSqlExecutionPlanStep.Builder`	`objectType(String objectType)` The descriptive modifier that further describes the type of object.
`SqlTuningTaskSqlExecutionPlanStep.Builder`	`operation(String operation)` The name of the operation performed at this step.
`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`	`options(String options)` The options used for the operation performed at this step.
`SqlTuningTaskSqlExecutionPlanStep.Builder`	`other(String other)` Information about parallel execution servers and parallel queries
`SqlTuningTaskSqlExecutionPlanStep.Builder`	`otherTag(String otherTag)` Describes the function of the SQL text in the OTHER column.
`SqlTuningTaskSqlExecutionPlanStep.Builder`	`parentStepId(Integer parentStepId)` The ID of the next step that operates on the results of this step.
`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`	`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`	`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`	`planHashValue(Long planHashValue)` The numerical representation of the SQL execution plan.
`SqlTuningTaskSqlExecutionPlanStep.Builder`	`position(Integer position)` The order of processing for steps with the same parent ID.
`SqlTuningTaskSqlExecutionPlanStep.Builder`	`remarks(String remarks)` The place for comments that can be added to the steps of the execution plan.
`SqlTuningTaskSqlExecutionPlanStep.Builder`	`stepId(Integer stepId)` The identification number of a step in the SQL execution plan.
`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`	`time(Long time)` The elapsed time (in seconds) of the operation as estimated by the CBO.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - Builder
```
public Builder()
```
- Method Detail
  - planHashValue
```
public SqlTuningTaskSqlExecutionPlanStep.Builder planHashValue(Long planHashValue)
```
    The numerical representation of the SQL execution plan.
    
    Parameters:
    
    planHashValue - the value to set
    
    Returns:
    
    this builder
  - stepId
```
public SqlTuningTaskSqlExecutionPlanStep.Builder stepId(Integer stepId)
```
    The identification number of a step in the SQL execution plan. This is unique within the SQL execution plan. This is not the OCID.
    
    Parameters:
    
    stepId - the value to set
    
    Returns:
    
    this builder
  - parentStepId
```
public SqlTuningTaskSqlExecutionPlanStep.Builder parentStepId(Integer parentStepId)
```
    The ID of the next step that operates on the results of this step. This is not the OCID.
    
    Parameters:
    
    parentStepId - the value to set
    
    Returns:
    
    this builder
  - position
```
public SqlTuningTaskSqlExecutionPlanStep.Builder position(Integer position)
```
    The order of processing for steps with the same parent ID.
    
    Parameters:
    
    position - the value to set
    
    Returns:
    
    this builder
  - operation
```
public SqlTuningTaskSqlExecutionPlanStep.Builder operation(String operation)
```
    The name of the operation performed at this step.
    
    Parameters:
    
    operation - the value to set
    
    Returns:
    
    this builder
  - options
```
public SqlTuningTaskSqlExecutionPlanStep.Builder options(String options)
```
    The options used for the operation performed at this step.
    
    Parameters:
    
    options - the value to set
    
    Returns:
    
    this builder
  - optimizerMode
```
public 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).
    
    Parameters:
    
    optimizerMode - the value to set
    
    Returns:
    
    this builder
  - cost
```
public SqlTuningTaskSqlExecutionPlanStep.Builder cost(Double cost)
```
    The cost of the current operation estimated by the cost-based optimizer (CBO).
    
    Parameters:
    
    cost - the value to set
    
    Returns:
    
    this builder
  - cardinality
```
public SqlTuningTaskSqlExecutionPlanStep.Builder cardinality(Long cardinality)
```
    The number of rows returned by the current operation (estimated by the CBO).
    
    Parameters:
    
    cardinality - the value to set
    
    Returns:
    
    this builder
  - bytes
```
public SqlTuningTaskSqlExecutionPlanStep.Builder bytes(Long bytes)
```
    The number of bytes returned by the current operation.
    
    Parameters:
    
    bytes - the value to set
    
    Returns:
    
    this builder
  - cpuCost
```
public SqlTuningTaskSqlExecutionPlanStep.Builder cpuCost(Double cpuCost)
```
    The CPU cost of the current operation.
    
    Parameters:
    
    cpuCost - the value to set
    
    Returns:
    
    this builder
  - ioCost
```
public SqlTuningTaskSqlExecutionPlanStep.Builder ioCost(Double ioCost)
```
    The I/O cost of the current operation.
    
    Parameters:
    
    ioCost - the value to set
    
    Returns:
    
    this builder
  - tempSpace
```
public SqlTuningTaskSqlExecutionPlanStep.Builder tempSpace(Long tempSpace)
```
    The temporary space usage (in bytes) of the operation (sort or hash-join) as estimated by the CBO.
    
    Parameters:
    
    tempSpace - the value to set
    
    Returns:
    
    this builder
  - time
```
public SqlTuningTaskSqlExecutionPlanStep.Builder time(Long time)
```
    The elapsed time (in seconds) of the operation as estimated by the CBO.
    
    Parameters:
    
    time - the value to set
    
    Returns:
    
    this builder
  - objectNode
```
public SqlTuningTaskSqlExecutionPlanStep.Builder objectNode(String objectNode)
```
    The name of the database link used to reference the object.
    
    Parameters:
    
    objectNode - the value to set
    
    Returns:
    
    this builder
  - objectOwner
```
public SqlTuningTaskSqlExecutionPlanStep.Builder objectOwner(String objectOwner)
```
    The owner of the object.
    
    Parameters:
    
    objectOwner - the value to set
    
    Returns:
    
    this builder
  - objectName
```
public SqlTuningTaskSqlExecutionPlanStep.Builder objectName(String objectName)
```
    The name of the object.
    
    Parameters:
    
    objectName - the value to set
    
    Returns:
    
    this builder
  - objectPosition
```
public SqlTuningTaskSqlExecutionPlanStep.Builder objectPosition(Integer objectPosition)
```
    The numbered position of the object name in the original SQL statement.
    
    Parameters:
    
    objectPosition - the value to set
    
    Returns:
    
    this builder
  - objectType
```
public SqlTuningTaskSqlExecutionPlanStep.Builder objectType(String objectType)
```
    The descriptive modifier that further describes the type of object.
    
    Parameters:
    
    objectType - the value to set
    
    Returns:
    
    this builder
  - partitionStart
```
public 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. The partionStart is the starting partition of the range. The partitionStop is the ending partition of the range.
    
    Parameters:
    
    partitionStart - the value to set
    
    Returns:
    
    this builder
  - partitionStop
```
public 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. The partionStart is the starting partition of the range. The partitionStop is the ending partition of the range.
    
    Parameters:
    
    partitionStop - the value to set
    
    Returns:
    
    this builder
  - partitionId
```
public 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.
    
    Parameters:
    
    partitionId - the value to set
    
    Returns:
    
    this builder
  - remarks
```
public SqlTuningTaskSqlExecutionPlanStep.Builder remarks(String remarks)
```
    The place for comments that can be added to the steps of the execution plan.
    
    Parameters:
    
    remarks - the value to set
    
    Returns:
    
    this builder
  - numberOfSearchColumn
```
public SqlTuningTaskSqlExecutionPlanStep.Builder numberOfSearchColumn(Integer numberOfSearchColumn)
```
    Number of index columns with start and stop keys (that is, the number of columns with matching predicates).
    
    Parameters:
    
    numberOfSearchColumn - the value to set
    
    Returns:
    
    this builder
  - other
```
public SqlTuningTaskSqlExecutionPlanStep.Builder other(String other)
```
    Information about parallel execution servers and parallel queries
    
    Parameters:
    
    other - the value to set
    
    Returns:
    
    this builder
  - otherTag
```
public SqlTuningTaskSqlExecutionPlanStep.Builder otherTag(String otherTag)
```
    Describes the function of the SQL text in the OTHER column.
    
    Parameters:
    
    otherTag - the value to set
    
    Returns:
    
    this builder
  - attribute
```
public SqlTuningTaskSqlExecutionPlanStep.Builder attribute(String attribute)
```
    The text string identifying the type of execution plan.
    
    Parameters:
    
    attribute - the value to set
    
    Returns:
    
    this builder
  - accessPredicates
```
public SqlTuningTaskSqlExecutionPlanStep.Builder accessPredicates(String accessPredicates)
```
    The predicates used to locate rows in an access structure. For example, start or stop predicates for an index range scan.
    
    Parameters:
    
    accessPredicates - the value to set
    
    Returns:
    
    this builder
  - filterPredicates
```
public SqlTuningTaskSqlExecutionPlanStep.Builder filterPredicates(String filterPredicates)
```
    The predicates used to filter rows before producing them.
    
    Parameters:
    
    filterPredicates - the value to set
    
    Returns:
    
    this builder
  - build
```
public SqlTuningTaskSqlExecutionPlanStep build()
```
  - copy
```
public SqlTuningTaskSqlExecutionPlanStep.Builder copy(SqlTuningTaskSqlExecutionPlanStep model)
```

Class SqlTuningTaskSqlExecutionPlanStep.Builder

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

Builder

Method Detail

planHashValue

stepId

parentStepId

position

operation

options

optimizerMode

cost

cardinality

bytes

cpuCost

ioCost

tempSpace

time

objectNode

objectOwner

objectName

objectPosition

objectType

partitionStart

partitionStop

partitionId

remarks

numberOfSearchColumn

other

otherTag

attribute

accessPredicates

filterPredicates

build

copy