RealNestedLoopLeftOuterJoinStatistics (Apache Derby V10.14 Internals)

java.lang.Object
- org.apache.derby.impl.sql.execute.rts.RealBasicNoPutResultSetStatistics
- - org.apache.derby.impl.sql.execute.rts.RealNoPutResultSetStatistics
  - - org.apache.derby.impl.sql.execute.rts.RealJoinResultSetStatistics
    - - org.apache.derby.impl.sql.execute.rts.RealNestedLoopJoinStatistics
      - org.apache.derby.impl.sql.execute.rts.RealNestedLoopLeftOuterJoinStatistics

All Implemented Interfaces:

ResultSetStatistics, XPLAINable

Direct Known Subclasses:

RealHashLeftOuterJoinStatistics
```
public class RealNestedLoopLeftOuterJoinStatistics
extends RealNestedLoopJoinStatistics
```
ResultSetStatistics implemenation for NestedLoopLeftOuterJoinResultSet.

Field Summary

Fields
Modifier and Type Field Description

int emptyRightRowsReturned
- Fields inherited from class org.apache.derby.impl.sql.execute.rts.RealBasicNoPutResultSetStatistics
  closeTime, constructorTime, inspectDesc, inspectNum, inspectOverall, nextTime, numOpens, openTime, optimizerEstimatedCost, optimizerEstimatedRowCount, rowsFiltered, rowsSeen
- Fields inherited from class org.apache.derby.impl.sql.execute.rts.RealJoinResultSetStatistics
  restrictionTime, rowsReturned, rowsSeenLeft, rowsSeenRight, userSuppliedOptimizerOverrides
- Fields inherited from class org.apache.derby.impl.sql.execute.rts.RealNestedLoopJoinStatistics
  leftResultSetStatistics, nodeName, oneRowRightSide, resultSetName, rightResultSetStatistics
- Fields inherited from class org.apache.derby.impl.sql.execute.rts.RealNoPutResultSetStatistics
  indent, resultSetNumber, sourceDepth, subIndent

Fields
Modifier and Type	Field	Description
`int`	`emptyRightRowsReturned`

Constructor Summary

Constructors
Constructor	Description
RealNestedLoopLeftOuterJoinStatistics(int numOpens, int rowsSeen, int rowsFiltered, long constructorTime, long openTime, long nextTime, long closeTime, int resultSetNumber, int rowsSeenLeft, int rowsSeenRight, int rowsReturned, long restrictionTime, double optimizerEstimatedRowCount, double optimizerEstimatedCost, java.lang.String userSuppliedOptimizerOverrides, ResultSetStatistics leftResultSetStatistics, ResultSetStatistics rightResultSetStatistics, int emptyRightRowsReturned)

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`java.lang.Object`	`getResultSetDescriptor(java.lang.Object rsID, java.lang.Object parentID, java.lang.Object scanID, java.lang.Object sortID, java.lang.Object stmtID, java.lang.Object timingID)`
`java.lang.String`	`getRSXplainDetails()`
`java.lang.String`	`getRSXplainType()`
`java.lang.String`	`getScanStatisticsText(java.lang.String tableName, int depth)`	Return information on the scan nodes from the statement execution plan as a String.
`java.lang.String`	`getStatementExecutionPlanText(int depth)`	Return the statement execution plan as a String.
`protected void`	`setNames()`
`java.lang.String`	`toString()`

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

Methods inherited from class org.apache.derby.impl.sql.execute.rts.RealBasicNoPutResultSetStatistics
dumpEstimatedCosts, dumpTimeStats, getChildrenTime, getEstimatedRowCount, getNodeOn, getNodeTime, getScanPropsDescriptor, getSortPropsDescriptor, getTotalTime

Methods inherited from class org.apache.derby.impl.sql.execute.rts.RealJoinResultSetStatistics
getResultSetTimingsDescriptor

Methods inherited from class org.apache.derby.impl.sql.execute.rts.RealNestedLoopJoinStatistics
accept, getChildren, getNodeName

Methods inherited from class org.apache.derby.impl.sql.execute.rts.RealNoPutResultSetStatistics
initFormatInfo

Field Detail
- emptyRightRowsReturned
```
public int emptyRightRowsReturned
```

Constructor Detail

RealNestedLoopLeftOuterJoinStatistics

public RealNestedLoopLeftOuterJoinStatistics(int numOpens,
                                             int rowsSeen,
                                             int rowsFiltered,
                                             long constructorTime,
                                             long openTime,
                                             long nextTime,
                                             long closeTime,
                                             int resultSetNumber,
                                             int rowsSeenLeft,
                                             int rowsSeenRight,
                                             int rowsReturned,
                                             long restrictionTime,
                                             double optimizerEstimatedRowCount,
                                             double optimizerEstimatedCost,
                                             java.lang.String userSuppliedOptimizerOverrides,
                                             ResultSetStatistics leftResultSetStatistics,
                                             ResultSetStatistics rightResultSetStatistics,
                                             int emptyRightRowsReturned)

Method Detail
- getStatementExecutionPlanText
```
public java.lang.String getStatementExecutionPlanText(int depth)
```
  Return the statement execution plan as a String.
  
  Specified by:
  
  getStatementExecutionPlanText in interface ResultSetStatistics
  
  Overrides:
  
  getStatementExecutionPlanText in class RealNestedLoopJoinStatistics
  
  Parameters:
  
  depth - Indentation level.
  
  Returns:
  
  String The statement execution plan as a String.
- getScanStatisticsText
```
public java.lang.String getScanStatisticsText(java.lang.String tableName,
                                              int depth)
```
  Return information on the scan nodes from the statement execution plan as a String.
  
  Specified by:
  
  getScanStatisticsText in interface ResultSetStatistics
  
  Overrides:
  
  getScanStatisticsText in class RealNestedLoopJoinStatistics
  
  Parameters:
  
  depth - Indentation level.
  
  tableName - if not NULL then print information for this table only
  
  Returns:
  
  String The information on the scan nodes from the statement execution plan as a String.
- toString
```
public java.lang.String toString()
```
  Overrides:
  
  toString in class RealNestedLoopJoinStatistics
- setNames
```
protected void setNames()
```
  Overrides:
  
  setNames in class RealNestedLoopJoinStatistics
- getRSXplainType
```
public java.lang.String getRSXplainType()
```
  Specified by:
  
  getRSXplainType in interface XPLAINable
  
  Overrides:
  
  getRSXplainType in class RealNestedLoopJoinStatistics
- getRSXplainDetails
```
public java.lang.String getRSXplainDetails()
```
  Specified by:
  
  getRSXplainDetails in interface XPLAINable
  
  Overrides:
  
  getRSXplainDetails in class RealNestedLoopJoinStatistics
- getResultSetDescriptor
```
public java.lang.Object getResultSetDescriptor(java.lang.Object rsID,
                                               java.lang.Object parentID,
                                               java.lang.Object scanID,
                                               java.lang.Object sortID,
                                               java.lang.Object stmtID,
                                               java.lang.Object timingID)
```
  Specified by:
  
  getResultSetDescriptor in interface XPLAINable
  
  Overrides:
  
  getResultSetDescriptor in class RealJoinResultSetStatistics

Class RealNestedLoopLeftOuterJoinStatistics

Field Summary

Fields inherited from class org.apache.derby.impl.sql.execute.rts.RealBasicNoPutResultSetStatistics

Fields inherited from class org.apache.derby.impl.sql.execute.rts.RealJoinResultSetStatistics

Fields inherited from class org.apache.derby.impl.sql.execute.rts.RealNestedLoopJoinStatistics

Fields inherited from class org.apache.derby.impl.sql.execute.rts.RealNoPutResultSetStatistics

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Methods inherited from class org.apache.derby.impl.sql.execute.rts.RealBasicNoPutResultSetStatistics

Methods inherited from class org.apache.derby.impl.sql.execute.rts.RealJoinResultSetStatistics

Methods inherited from class org.apache.derby.impl.sql.execute.rts.RealNestedLoopJoinStatistics

Methods inherited from class org.apache.derby.impl.sql.execute.rts.RealNoPutResultSetStatistics

Field Detail

emptyRightRowsReturned

Constructor Detail

RealNestedLoopLeftOuterJoinStatistics

Method Detail

getStatementExecutionPlanText

getScanStatisticsText

toString

setNames

getRSXplainType

getRSXplainDetails

getResultSetDescriptor