Apache Derby Database Engine and Embedded JDBC Driver 10.17.1.0 · org.apache.derby.impl.sql.compile.SubqueryList

Access	Constructor and Description
pack-priv	SubqueryList(ContextManager cm)

Method Summary

Modifier and Type	Method and Description
pack-priv void	addSubqueryNode(SubqueryNode A SubqueryNode to add to the list subqueryNode) Add a subquery to the list.
pack-priv void	decrementLevel(int The amount to decrement by. decrement) Decrement (query block) level (0-based) for all of the tables in this subquery list.
pack-priv void	markHavingSubqueries() Mark all of the subqueries in this list as being part of a having clause, so we can avoid flattening later.
pack-priv void	markWhereSubqueries() Mark all of the subqueries in this list as being part of a where clause so we can avoid flattening later if needed.
pack-priv void	modifyAccessPaths() Modify the access paths for all subqueries in this list.
pack-priv void	optimize(DataDictionary The data dictionary to use for optimization dataDictionary, double The optimizer's estimate of the number of times this subquery will be executed. outerRows) Optimize the subqueries in this list.
public boolean	Returns: true if references SESSION schema tables, else false referencesSessionSchema() Overrides org.apache.derby.impl.sql.compile.QueryTreeNode.referencesSessionSchema. Return true if the node references SESSION schema tables (temporary or permanent)
pack-priv boolean	Returns: true if found, else false referencesTarget(String Table name (String) to search for. name, boolean Whether or not name is for a base table baseTable) Search to see if a query references the specifed table name.
pack-priv void	setPointOfAttachment(int The point of attachment pointOfAttachment) Set the point of attachment in all subqueries in this list.

Inherited from org.apache.derby.impl.sql.compile.QueryTreeNodeVector:: acceptChildren addElement destructiveAppend elementAt indexOf insertElementAt iterator nondestructiveAppend printSubNodes removeAllElements removeElement removeElementAt setElementAt size

SubqueryList	back to summary
pack-priv SubqueryList(ContextManager cm)

Method Detail

addSubqueryNode	back to summary
pack-priv void addSubqueryNode(SubqueryNode subqueryNode) throws StandardException Add a subquery to the list. Parameters subqueryNode:SubqueryNode A SubqueryNode to add to the list

addSubqueryNode

back to summary

pack-priv void addSubqueryNode(SubqueryNode subqueryNode) throws StandardException

Add a subquery to the list.

Parameters

subqueryNode:SubqueryNode: A SubqueryNode to add to the list

decrementLevel	back to summary
pack-priv void decrementLevel(int decrement) Decrement (query block) level (0-based) for all of the tables in this subquery list. This is useful when flattening a subquery. Parameters decrement:int The amount to decrement by.

decrementLevel

back to summary

pack-priv void decrementLevel(int decrement)

Decrement (query block) level (0-based) for all of the tables in this subquery list. This is useful when flattening a subquery.

Parameters

decrement:int: The amount to decrement by.

markHavingSubqueries	back to summary
pack-priv void markHavingSubqueries() Mark all of the subqueries in this list as being part of a having clause, so we can avoid flattening later.

markWhereSubqueries	back to summary
pack-priv void markWhereSubqueries() Mark all of the subqueries in this list as being part of a where clause so we can avoid flattening later if needed.

modifyAccessPaths back to summary

modifyAccessPaths	back to summary
pack-priv void modifyAccessPaths() throws StandardException Modify the access paths for all subqueries in this list. Exceptions StandardException: Thrown on error See Also `ResultSetNode#modifyAccessPaths`

pack-priv void modifyAccessPaths() throws StandardException

Modify the access paths for all subqueries in this list.

Exceptions

StandardException:: Thrown on error

See Also

ResultSetNode#modifyAccessPaths

optimize	back to summary
pack-priv void optimize(DataDictionary dataDictionary, double outerRows) throws StandardException Optimize the subqueries in this list. Parameters dataDictionary:DataDictionary The data dictionary to use for optimization outerRows:double The optimizer's estimate of the number of times this subquery will be executed. Exceptions StandardException: Thrown on error

optimize

back to summary

pack-priv void optimize(DataDictionary dataDictionary, double outerRows) throws StandardException

Optimize the subqueries in this list.

Parameters

dataDictionary:DataDictionary: The data dictionary to use for optimization
outerRows:double: The optimizer's estimate of the number of times this subquery will be executed.

Exceptions

StandardException:: Thrown on error

referencesSessionSchema	back to summary
public boolean referencesSessionSchema() throws StandardException Overrides org.apache.derby.impl.sql.compile.QueryTreeNode.referencesSessionSchema. Return true if the node references SESSION schema tables (temporary or permanent) Returns:boolean true if references SESSION schema tables, else false Annotations @Override Exceptions StandardException: Thrown on error

referencesSessionSchema

back to summary

public boolean referencesSessionSchema() throws StandardException

Overrides org.apache.derby.impl.sql.compile.QueryTreeNode.referencesSessionSchema.

Return true if the node references SESSION schema tables (temporary or permanent)

Returns:boolean

true if references SESSION schema tables, else false

Annotations

@Override

Exceptions

StandardException:: Thrown on error

referencesTarget	back to summary
pack-priv boolean referencesTarget(String name, boolean baseTable) throws StandardException Search to see if a query references the specifed table name. Parameters name:String Table name (String) to search for. baseTable:boolean Whether or not name is for a base table Returns:boolean true if found, else false Exceptions StandardException: Thrown on error

referencesTarget

back to summary

pack-priv boolean referencesTarget(String name, boolean baseTable) throws StandardException

Search to see if a query references the specifed table name.

Parameters

name:String: Table name (String) to search for.
baseTable:boolean: Whether or not name is for a base table

Returns:boolean

true if found, else false

Exceptions

StandardException:: Thrown on error

setPointOfAttachment	back to summary
pack-priv void setPointOfAttachment(int pointOfAttachment) throws StandardException Set the point of attachment in all subqueries in this list. Parameters pointOfAttachment:int The point of attachment Exceptions StandardException: Thrown on error

setPointOfAttachment

back to summary

pack-priv void setPointOfAttachment(int pointOfAttachment) throws StandardException

Set the point of attachment in all subqueries in this list.

Parameters

pointOfAttachment:int: The point of attachment

Exceptions

StandardException:: Thrown on error

pack-priv Class SubqueryList

Field Summary

Constructor Summary

Method Summary

Constructor Detail

Method Detail