Class SqlTuningTaskSqlExecutionPlanStep

A step in the SQL execution plan.

Inheritance

object

SqlTuningTaskSqlExecutionPlanStep

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Oci.DatabasemanagementService.Models

Assembly: OCI.DotNetSDK.Databasemanagement.dll

Syntax

public class SqlTuningTaskSqlExecutionPlanStep

Properties

AccessPredicates

Declaration

[JsonProperty(PropertyName = "accessPredicates")]
public string AccessPredicates { get; set; }

Property Value

Type	Description
string	The predicates used to locate rows in an access structure. For example, start or stop predicates for an index range scan.

Attribute

Declaration

[JsonProperty(PropertyName = "attribute")]
public string Attribute { get; set; }

Property Value

Type	Description
string	The text string identifying the type of execution plan.

Bytes

Declaration

[JsonProperty(PropertyName = "bytes")]
public long? Bytes { get; set; }

Property Value

Type	Description
long?	The number of bytes returned by the current operation.

Cardinality

Declaration

[JsonProperty(PropertyName = "cardinality")]
public long? Cardinality { get; set; }

Property Value

Type	Description
long?	The number of rows returned by the current operation (estimated by the CBO).

Cost

Declaration

[JsonProperty(PropertyName = "cost")]
public double Cost { get; set; }

Property Value

Type	Description
double	The cost of the current operation estimated by the cost-based optimizer (CBO).

CpuCost

Declaration

[JsonProperty(PropertyName = "cpuCost")]
public double CpuCost { get; set; }

Property Value

Type	Description
double	The CPU cost of the current operation.

FilterPredicates

Declaration

[JsonProperty(PropertyName = "filterPredicates")]
public string FilterPredicates { get; set; }

Property Value

Type	Description
string	The predicates used to filter rows before producing them.

IoCost

Declaration

[JsonProperty(PropertyName = "ioCost")]
public double IoCost { get; set; }

Property Value

Type	Description
double	The I/O cost of the current operation.

NumberOfSearchColumn

Declaration

[JsonProperty(PropertyName = "numberOfSearchColumn")]
public int? NumberOfSearchColumn { get; set; }

Property Value

Type	Description
int?	Number of index columns with start and stop keys (that is, the number of columns with matching predicates).

ObjectName

Declaration

[JsonProperty(PropertyName = "objectName")]
public string ObjectName { get; set; }

Property Value

Type	Description
string	The name of the object.

ObjectNode

Declaration

[JsonProperty(PropertyName = "objectNode")]
public string ObjectNode { get; set; }

Property Value

Type	Description
string	The name of the database link used to reference the object.

ObjectOwner

Declaration

[JsonProperty(PropertyName = "objectOwner")]
public string ObjectOwner { get; set; }

Property Value

Type	Description
string	The owner of the object.

ObjectPosition

Declaration

[JsonProperty(PropertyName = "objectPosition")]
public int? ObjectPosition { get; set; }

Property Value

Type	Description
int?	The numbered position of the object name in the original SQL statement.

ObjectType

Declaration

[JsonProperty(PropertyName = "objectType")]
public string ObjectType { get; set; }

Property Value

Type	Description
string	The descriptive modifier that further describes the type of object.

Operation

Declaration

[JsonProperty(PropertyName = "operation")]
public string Operation { get; set; }

Property Value

Type	Description
string	The name of the operation performed at this step.

OptimizerMode

Declaration

[JsonProperty(PropertyName = "optimizerMode")]
public string OptimizerMode { get; set; }

Property Value

Type	Description
string	The current mode of the optimizer, such as all_rows, first_rows_n (where n = 1, 10, 100, 1000, and so on).

Options

Declaration

[JsonProperty(PropertyName = "options")]
public string Options { get; set; }

Property Value

Type	Description
string	The options used for the operation performed at this step.

Other

Declaration

[JsonProperty(PropertyName = "other")]
public string Other { get; set; }

Property Value

Type	Description
string	Information about parallel execution servers and parallel queries

OtherTag

Declaration

[JsonProperty(PropertyName = "otherTag")]
public string OtherTag { get; set; }

Property Value

Type	Description
string	Describes the function of the SQL text in the OTHER column.

ParentStepId

Declaration

[JsonProperty(PropertyName = "parentStepId")]
public int? ParentStepId { get; set; }

Property Value

Type	Description
int?	The ID of the next step that operates on the results of this step. This is not the OCID.

PartitionId

Declaration

[JsonProperty(PropertyName = "partitionId")]
public int? PartitionId { get; set; }

Property Value

Type	Description
int?	The ID of the step in the execution plan that has computed the pair of values of partitionStart and partitionStop.

PartitionStart

Declaration

[JsonProperty(PropertyName = "partitionStart")]
public string PartitionStart { get; set; }

Property Value

Type	Description
string	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.

PartitionStop

Declaration

[JsonProperty(PropertyName = "partitionStop")]
public string PartitionStop { get; set; }

Property Value

Type	Description
string	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.

PlanHashValue

Declaration

[JsonProperty(PropertyName = "planHashValue")]
public long? PlanHashValue { get; set; }

Property Value

Type	Description
long?	The numerical representation of the SQL execution plan.

Position

Declaration

[JsonProperty(PropertyName = "position")]
public int? Position { get; set; }

Property Value

Type	Description
int?	The order of processing for steps with the same parent ID.

Remarks

Declaration

[JsonProperty(PropertyName = "remarks")]
public string Remarks { get; set; }

Property Value

Type	Description
string	The place for comments that can be added to the steps of the execution plan.

StepId

Declaration

[JsonProperty(PropertyName = "stepId")]
public int? StepId { get; set; }

Property Value

Type	Description
int?	The identification number of a step in the SQL execution plan. This is unique within the SQL execution plan. This is not the OCID.

TempSpace

Declaration

[JsonProperty(PropertyName = "tempSpace")]
public long? TempSpace { get; set; }

Property Value

Type	Description
long?	The temporary space usage (in bytes) of the operation (sort or hash-join) as estimated by the CBO.

Time

Declaration

[JsonProperty(PropertyName = "time")]
public long? Time { get; set; }

Property Value

Type	Description
long?	The elapsed time (in seconds) of the operation as estimated by the CBO.