Java Doc for ProjectRestrictNode.java in  » Database-DBMS » db-derby-10.2 » org » apache » derby » impl » sql » compile » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation
1. 6.0 JDK Core
2. 6.0 JDK Modules
3. 6.0 JDK Modules com.sun
4. 6.0 JDK Modules com.sun.java
5. 6.0 JDK Modules sun
6. 6.0 JDK Platform
7. Ajax
8. Apache Harmony Java SE
9. Aspect oriented
10. Authentication Authorization
11. Blogger System
12. Build
13. Byte Code
14. Cache
15. Chart
16. Chat
17. Code Analyzer
18. Collaboration
19. Content Management System
20. Database Client
21. Database DBMS
22. Database JDBC Connection Pool
23. Database ORM
24. Development
25. EJB Server geronimo
26. EJB Server GlassFish
27. EJB Server JBoss 4.2.1
28. EJB Server resin 3.1.5
29. ERP CRM Financial
30. ESB
31. Forum
32. GIS
33. Graphic Library
34. Groupware
35. HTML Parser
36. IDE
37. IDE Eclipse
38. IDE Netbeans
39. Installer
40. Internationalization Localization
41. Inversion of Control
42. Issue Tracking
43. J2EE
44. JBoss
45. JMS
46. JMX
47. Library
48. Mail Clients
49. Net
50. Parser
51. PDF
52. Portal
53. Profiler
54. Project Management
55. Report
56. RSS RDF
57. Rule Engine
58. Science
59. Scripting
60. Search Engine
61. Security
62. Sevlet Container
63. Source Control
64. Swing Library
65. Template Engine
66. Test Coverage
67. Testing
68. UML
69. Web Crawler
70. Web Framework
71. Web Mail
72. Web Server
73. Web Services
74. Web Services apache cxf 2.0.1
75. Web Services AXIS2
76. Wiki Engine
77. Workflow Engines
78. XML
79. XML UI
Java
Java Tutorial
Java Open Source
Jar File Download
Java Articles
Java Products
Java by API
Photoshop Tutorials
Maya Tutorials
Flash Tutorials
3ds-Max Tutorials
Illustrator Tutorials
GIMP Tutorials
C# / C Sharp
C# / CSharp Tutorial
C# / CSharp Open Source
ASP.Net
ASP.NET Tutorial
JavaScript DHTML
JavaScript Tutorial
JavaScript Reference
HTML / CSS
HTML CSS Reference
C / ANSI-C
C Tutorial
C++
C++ Tutorial
Ruby
PHP
Python
Python Tutorial
Python Open Source
SQL Server / T-SQL
SQL Server / T-SQL Tutorial
Oracle PL / SQL
Oracle PL/SQL Tutorial
PostgreSQL
SQL / MySQL
MySQL Tutorial
VB.Net
VB.Net Tutorial
Flash / Flex / ActionScript
VBA / Excel / Access / Word
XML
XML Tutorial
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
Java Source Code / Java Documentation » Database DBMS » db derby 10.2 » org.apache.derby.impl.sql.compile 
Source Cross Reference  Class Diagram Java Document (Java Doc) 


java.lang.Object
   org.apache.derby.impl.sql.compile.QueryTreeNode
      org.apache.derby.impl.sql.compile.ResultSetNode
         org.apache.derby.impl.sql.compile.FromTable
            org.apache.derby.impl.sql.compile.SingleChildResultSetNode
               org.apache.derby.impl.sql.compile.ProjectRestrictNode

ProjectRestrictNode
public class ProjectRestrictNode extends SingleChildResultSetNode (Code)
A ProjectRestrictNode represents a result set for any of the basic DML operations: SELECT, INSERT, UPDATE, and DELETE. For INSERT with a VALUES clause, restriction will be null. For both INSERT and UPDATE, the resultColumns in the selectList will contain the names of the columns being inserted into or updated. NOTE: A ProjectRestrictNode extends FromTable since it can exist in a FromList.
author:
   Jeff Lichtman


Field Summary
 ValueNodeconstantRestriction
     Constant expressions to be evaluated here.
 SubqueryListprojectSubquerys
    
 SubqueryListrestrictSubquerys
    
public  ValueNoderestriction
     The ValueNode for the restriction to be evaluated here.
public  PredicateListrestrictionList
    


Method Summary
public  Visitableaccept(Visitor v)
     Accept a visitor, and call v.visit() on child nodes as necessary.
public  ResultSetNodeaddNewPredicate(Predicate predicate)
     Add a new predicate to the list.
public  ResultSetNodeconsiderMaterialization(JBitSet outerTables)
    
public  booleanconsiderSortAvoidancePath()
    
public  ResultSetNodeensurePredicateList(int numTables)
     Ensure that the top of the RSN tree has a PredicateList.
Parameters:
  numTables - The number of tables in the query.
public  booleanfeasibleJoinStrategy(OptimizablePredicateList predList, Optimizer optimizer)
    
public  booleanflattenableInFromSubquery(FromList fromList)
     Evaluate whether or not the subquery in a FromSubquery is flattenable.
public  voidgenerate(ActivationClassBuilder acb, MethodBuilder mb)
    
public  voidgenerateNOPProjectRestrict()
     Bypass the generation of this No-Op ProjectRestrict, and just generate its child result set.
public  voidgenerateResultSet(ExpressionClassBuilder acb, MethodBuilder mb)
     General logic shared by Core compilation.
public  AccessPathgetBestAccessPath()
    
public  AccessPathgetBestSortAvoidancePath()
    
public  CostEstimategetCostEstimate()
     Get the CostEstimate for this ProjectRestrictNode.
public  AccessPathgetCurrentAccessPath()
    
public  CostEstimategetFinalCostEstimate()
     Get the final CostEstimate for this ProjectRestrictNode.
protected  FromTablegetFromTableByName(String name, String schemaName, boolean exactMatch)
     Determine whether or not the specified name is an exposed name in the current query block.
Parameters:
  name - The specified name to search for as an exposed name.
Parameters:
  schemaName - Schema name, if non-null.
Parameters:
  exactMatch - Whether or not we need an exact match on specified schema and tablenames or match on table id.
 PredicateListgetRestrictionList()
     Return the restriction list from this node.
public  intgetTableNumber()
    
public  AccessPathgetTrulyTheBestAccessPath()
    
 StringgetUserSpecifiedJoinStrategy()
     Return the user specified join strategy, if any for this table.
public  voidinit(Object childResult, Object projection, Object restriction, Object restrictionList, Object projectSubquerys, Object restrictSubquerys, Object tableProperties)
     Initializer for a ProjectRestrictNode.
 booleanisPossibleDistinctScan(Set distinctColumns)
     Is it possible to do a distinct scan on this ResultSet tree.
public  booleanlegalJoinOrder(JBitSet assignedTableMap)
    
 voidmarkForDistinctScan()
     Mark the underlying scan as a distinct scan.
public  OptimizablemodifyAccessPath(JBitSet outerTables)
    
public  booleannextAccessPath(Optimizer optimizer, OptimizablePredicateList predList, RowOrdering rowOrdering)
    
 booleannopProjectRestrict()
     Determine whether this ProjectRestrict does anything.
public  ResultSetNodeoptimize(DataDictionary dataDictionary, PredicateList predicates, double outerRows)
     Optimize this ProjectRestrictNode.
public  CostEstimateoptimizeIt(Optimizer optimizer, OptimizablePredicateList predList, CostEstimate outerCost, RowOrdering rowOrdering)
    
public  ResultSetNodepreprocess(int numTables, GroupByList gbl, FromList fromList)
     Put a ProjectRestrictNode on top of each FromTable in the FromList. ColumnReferences must continue to point to the same ResultColumn, so that ResultColumn must percolate up to the new PRN.
 voidprintRememberingBestAccessPath(int planType, AccessPath bestPath)
    
public  voidprintSubNodes(int depth)
     Prints the sub-nodes of this object.
public  voidpullOptPredicates(OptimizablePredicateList optimizablePredicates)
    
public  voidpushExpressions(PredicateList predicateList)
     Push expressions down to the first ResultSetNode which can do expression evaluation and has the same referenced table map. RESOLVE - This means only pushing down single table expressions to ProjectRestrictNodes today.
public  booleanpushOptPredicate(OptimizablePredicate optimizablePredicate)
    
public  voidrememberAsBest(int planType, Optimizer optimizer)
    
public  voidrememberSortAvoidancePath()
    
public  voidsetRefActionInfo(long fkIndexConglomId, int[] fkColArray, String parentResultSetId, boolean dependentScan)
     set the Information gathered from the parent table that is required to peform a referential action on dependent table.
public  voidstartOptimizing(Optimizer optimizer, RowOrdering rowOrdering)
    
public  doubleuniqueJoin(OptimizablePredicateList predList)
    
public  intupdateTargetLockMode()
     Get the lock mode for the target of an update statement (a delete or update).
public  voidverifyProperties(DataDictionary dDictionary)
    

Field Detail
constantRestriction
ValueNode constantRestriction(Code)
Constant expressions to be evaluated here.



projectSubquerys
SubqueryList projectSubquerys(Code)
List of subqueries in projection



restrictSubquerys
SubqueryList restrictSubquerys(Code)
List of subqueries in restriction



restriction
public ValueNode restriction(Code)
The ValueNode for the restriction to be evaluated here.



restrictionList
public PredicateList restrictionList(Code)
Restriction as a PredicateList





Method Detail
accept
public Visitable accept(Visitor v) throws StandardException(Code)
Accept a visitor, and call v.visit() on child nodes as necessary.
Parameters:
  v - the visitor
exception:
  StandardException - on error



addNewPredicate
public ResultSetNode addNewPredicate(Predicate predicate) throws StandardException(Code)
Add a new predicate to the list. This is useful when doing subquery transformations, when we build a new predicate with the left side of the subquery operator and the subquery's result column.
Parameters:
  predicate - The predicate to add ResultSetNode The new top of the tree.
exception:
  StandardException - Thrown on error



considerMaterialization
public ResultSetNode considerMaterialization(JBitSet outerTables) throws StandardException(Code)
Consider materialization for this ResultSet tree if it is valid and cost effective (It is not valid if incorrect results would be returned.) Top of the new/same ResultSet tree.
exception:
  StandardException - Thrown on error



considerSortAvoidancePath
public boolean considerSortAvoidancePath()(Code)

See Also:   Optimizable.considerSortAvoidancePath
See Also:   



ensurePredicateList
public ResultSetNode ensurePredicateList(int numTables) throws StandardException(Code)
Ensure that the top of the RSN tree has a PredicateList.
Parameters:
  numTables - The number of tables in the query. ResultSetNode A RSN tree with a node which has a PredicateList on top.
exception:
  StandardException - Thrown on error



feasibleJoinStrategy
public boolean feasibleJoinStrategy(OptimizablePredicateList predList, Optimizer optimizer) throws StandardException(Code)

See Also:   Optimizable.feasibleJoinStrategy
exception:
  StandardException - Thrown on error



flattenableInFromSubquery
public boolean flattenableInFromSubquery(FromList fromList)(Code)
Evaluate whether or not the subquery in a FromSubquery is flattenable. Currently, a FSqry is flattenable if all of the following are true: o Subquery is a SelectNode. o It contains no top level subqueries. (RESOLVE - we can relax this) o It does not contain a group by or having clause o It does not contain aggregates.
Parameters:
  fromList - The outer from list boolean Whether or not the FromSubquery is flattenable.



generate
public void generate(ActivationClassBuilder acb, MethodBuilder mb) throws StandardException(Code)
For joins, the tree will be (nodes are left out if the clauses are empty): ProjectRestrictResultSet -- for the having and the select list SortResultSet -- for the group by list ProjectRestrictResultSet -- for the where and the select list (if no group or having) the result set for the fromList
exception:
  StandardException - Thrown on error



generateNOPProjectRestrict
public void generateNOPProjectRestrict() throws StandardException(Code)
Bypass the generation of this No-Op ProjectRestrict, and just generate its child result set.
exception:
  StandardException - Thrown on error



generateResultSet
public void generateResultSet(ExpressionClassBuilder acb, MethodBuilder mb) throws StandardException(Code)
General logic shared by Core compilation.
Parameters:
  acb - The ExpressionClassBuilder for the class being built
Parameters:
  mb - The method the expression will go into
exception:
  StandardException - Thrown on error



getBestAccessPath
public AccessPath getBestAccessPath()(Code)

See Also:   Optimizable.getBestAccessPath
See Also:   



getBestSortAvoidancePath
public AccessPath getBestSortAvoidancePath()(Code)

See Also:   Optimizable.getBestSortAvoidancePath
See Also:   



getCostEstimate
public CostEstimate getCostEstimate()(Code)
Get the CostEstimate for this ProjectRestrictNode. The CostEstimate for this ProjectRestrictNode, which isthe cost estimate for the child node.



getCurrentAccessPath
public AccessPath getCurrentAccessPath()(Code)

See Also:   Optimizable.getCurrentAccessPath
See Also:   



getFinalCostEstimate
public CostEstimate getFinalCostEstimate() throws StandardException(Code)
Get the final CostEstimate for this ProjectRestrictNode. The final CostEstimate for this ProjectRestrictNode, which isthe final cost estimate for the child node.



getFromTableByName
protected FromTable getFromTableByName(String name, String schemaName, boolean exactMatch) throws StandardException(Code)
Determine whether or not the specified name is an exposed name in the current query block.
Parameters:
  name - The specified name to search for as an exposed name.
Parameters:
  schemaName - Schema name, if non-null.
Parameters:
  exactMatch - Whether or not we need an exact match on specified schema and tablenames or match on table id. The FromTable, if any, with the exposed name.
exception:
  StandardException - Thrown on error



getRestrictionList
PredicateList getRestrictionList()(Code)
Return the restriction list from this node. The restriction list from this node.



getTableNumber
public int getTableNumber()(Code)

See Also:   Optimizable.getTableNumber
See Also:   



getTrulyTheBestAccessPath
public AccessPath getTrulyTheBestAccessPath()(Code)

See Also:   Optimizable.getTrulyTheBestAccessPath
See Also:   



getUserSpecifiedJoinStrategy
String getUserSpecifiedJoinStrategy()(Code)
Return the user specified join strategy, if any for this table. The user specified join strategy, if any for this table.



init
public void init(Object childResult, Object projection, Object restriction, Object restrictionList, Object projectSubquerys, Object restrictSubquerys, Object tableProperties)(Code)
Initializer for a ProjectRestrictNode.
Parameters:
  childResult - The child ResultSetNode
Parameters:
  projection - The result column list for the projection
Parameters:
  restriction - An expression representing the restriction to be evaluated here.
Parameters:
  restrictionList - Restriction as a PredicateList
Parameters:
  projectSubquerys - List of subqueries in the projection
Parameters:
  restrictSubquerys - List of subqueries in the restriction
Parameters:
  tableProperties - Properties list associated with the table



isPossibleDistinctScan
boolean isPossibleDistinctScan(Set distinctColumns)(Code)
Is it possible to do a distinct scan on this ResultSet tree. (See SelectNode for the criteria.)
Parameters:
  distinctColumns - the set of distinct columns Whether or not it is possible to do a distinct scan on this ResultSet tree.



legalJoinOrder
public boolean legalJoinOrder(JBitSet assignedTableMap)(Code)

See Also:   Optimizable.legalJoinOrder



markForDistinctScan
void markForDistinctScan()(Code)
Mark the underlying scan as a distinct scan.



modifyAccessPath
public Optimizable modifyAccessPath(JBitSet outerTables) throws StandardException(Code)

See Also:   Optimizable.modifyAccessPath
exception:
  StandardException - Thrown on error



nextAccessPath
public boolean nextAccessPath(Optimizer optimizer, OptimizablePredicateList predList, RowOrdering rowOrdering) throws StandardException(Code)

See Also:   Optimizable.nextAccessPath
exception:
  StandardException - Thrown on error



nopProjectRestrict
boolean nopProjectRestrict()(Code)
Determine whether this ProjectRestrict does anything. If it doesn't filter out any rows or columns, it's a No-Op. true if this ProjectRestrict is a No-Op.



optimize
public ResultSetNode optimize(DataDictionary dataDictionary, PredicateList predicates, double outerRows) throws StandardException(Code)
Optimize this ProjectRestrictNode.
Parameters:
  dataDictionary - The DataDictionary to use for optimization
Parameters:
  predicates - The PredicateList to optimize. This shouldbe a join predicate.
Parameters:
  outerRows - The number of outer joining rows ResultSetNode The top of the optimized subtree
exception:
  StandardException - Thrown on error



optimizeIt
public CostEstimate optimizeIt(Optimizer optimizer, OptimizablePredicateList predList, CostEstimate outerCost, RowOrdering rowOrdering) throws StandardException(Code)

See Also:   Optimizable.optimizeIt
exception:
  StandardException - Thrown on error



preprocess
public ResultSetNode preprocess(int numTables, GroupByList gbl, FromList fromList) throws StandardException(Code)
Put a ProjectRestrictNode on top of each FromTable in the FromList. ColumnReferences must continue to point to the same ResultColumn, so that ResultColumn must percolate up to the new PRN. However, that ResultColumn will point to a new expression, a VirtualColumnNode, which points to the FromTable and the ResultColumn that is the source for the ColumnReference. (The new PRN will have the original of the ResultColumnList and the ResultColumns from that list. The FromTable will get shallow copies of the ResultColumnList and its ResultColumns. ResultColumn.expression will remain at the FromTable, with the PRN getting a new VirtualColumnNode for each ResultColumn.expression.) We then project out the non-referenced columns. If there are no referenced columns, then the PRN's ResultColumnList will consist of a single ResultColumn whose expression is 1.
Parameters:
  numTables - Number of tables in the DML Statement
Parameters:
  gbl - The group by list, if any
Parameters:
  fromList - The from list, if any The generated ProjectRestrictNode atop the original FromTable.
exception:
  StandardException - Thrown on error



printRememberingBestAccessPath
void printRememberingBestAccessPath(int planType, AccessPath bestPath)(Code)



printSubNodes
public void printSubNodes(int depth)(Code)
Prints the sub-nodes of this object. See QueryTreeNode.java for how tree printing is supposed to work.
Parameters:
  depth - The depth of this node in the tree



pullOptPredicates
public void pullOptPredicates(OptimizablePredicateList optimizablePredicates) throws StandardException(Code)

See Also:   Optimizable.pullOptPredicates
exception:
  StandardException - Thrown on error



pushExpressions
public void pushExpressions(PredicateList predicateList) throws StandardException(Code)
Push expressions down to the first ResultSetNode which can do expression evaluation and has the same referenced table map. RESOLVE - This means only pushing down single table expressions to ProjectRestrictNodes today. Once we have a better understanding of how the optimizer will work, we can push down join clauses.
Parameters:
  predicateList - The PredicateList.
exception:
  StandardException - Thrown on error



pushOptPredicate
public boolean pushOptPredicate(OptimizablePredicate optimizablePredicate) throws StandardException(Code)

See Also:   Optimizable.pushOptPredicate
exception:
  StandardException - Thrown on error



rememberAsBest
public void rememberAsBest(int planType, Optimizer optimizer) throws StandardException(Code)

See Also:   Optimizable.rememberAsBest
See Also:   
exception:
  StandardException - Thrown on error



rememberSortAvoidancePath
public void rememberSortAvoidancePath()(Code)

See Also:   Optimizable.rememberSortAvoidancePath
See Also:   



setRefActionInfo
public void setRefActionInfo(long fkIndexConglomId, int[] fkColArray, String parentResultSetId, boolean dependentScan)(Code)
set the Information gathered from the parent table that is required to peform a referential action on dependent table.



startOptimizing
public void startOptimizing(Optimizer optimizer, RowOrdering rowOrdering)(Code)

See Also:   Optimizable.startOptimizing
See Also:   



uniqueJoin
public double uniqueJoin(OptimizablePredicateList predList) throws StandardException(Code)

See Also:   Optimizable.uniqueJoin
exception:
  StandardException - Thrown on error



updateTargetLockMode
public int updateTargetLockMode()(Code)
Get the lock mode for the target of an update statement (a delete or update). The update mode will always be row for CurrentOfNodes. It will be table if there is no where clause. The lock mode



verifyProperties
public void verifyProperties(DataDictionary dDictionary) throws StandardException(Code)

See Also:   Optimizable.verifyProperties
See Also:   
exception:
  StandardException - Thrown on error



Fields inherited from org.apache.derby.impl.sql.compile.SingleChildResultSetNode
ResultSetNode childResult(Code)(Java Doc)
protected boolean hasTrulyTheBestAccessPath(Code)(Java Doc)

Methods inherited from org.apache.derby.impl.sql.compile.SingleChildResultSetNode
public Visitable accept(Visitor v) throws StandardException(Code)(Java Doc)
public ResultSetNode addNewPredicate(Predicate predicate) throws StandardException(Code)(Java Doc)
public ResultSetNode changeAccessPath() throws StandardException(Code)(Java Doc)
void decrementLevel(int decrement)(Code)(Java Doc)
public ResultSetNode ensurePredicateList(int numTables) throws StandardException(Code)(Java Doc)
public boolean flattenableInFromSubquery(FromList fromList)(Code)(Java Doc)
public boolean forUpdate()(Code)(Java Doc)
public ResultSetNode getChildResult()(Code)(Java Doc)
public CostEstimate getFinalCostEstimate() throws StandardException(Code)(Java Doc)
protected FromTable getFromTableByName(String name, String schemaName, boolean exactMatch) throws StandardException(Code)(Java Doc)
public AccessPath getTrulyTheBestAccessPath()(Code)(Java Doc)
public void init(Object childResult, Object tableProperties)(Code)(Java Doc)
public void initAccessPaths(Optimizer optimizer)(Code)(Java Doc)
public boolean isNotExists()(Code)(Java Doc)
public boolean isOneRowResultSet() throws StandardException(Code)(Java Doc)
boolean isOrderedOn(ColumnReference[] crs, boolean permuteOrdering, Vector fbtVector) throws StandardException(Code)(Java Doc)
void markOrderingDependent()(Code)(Java Doc)
public ResultSetNode modifyAccessPaths() throws StandardException(Code)(Java Doc)
public ResultSetNode optimize(DataDictionary dataDictionary, PredicateList predicates, double outerRows) throws StandardException(Code)(Java Doc)
public ResultSetNode preprocess(int numTables, GroupByList gbl, FromList fromList) throws StandardException(Code)(Java Doc)
public void printSubNodes(int depth)(Code)(Java Doc)
public void pullOptPredicates(OptimizablePredicateList optimizablePredicates) throws StandardException(Code)(Java Doc)
public void pushExpressions(PredicateList predicateList) throws StandardException(Code)(Java Doc)
public boolean referencesSessionSchema() throws StandardException(Code)(Java Doc)
public boolean referencesTarget(String name, boolean baseTable) throws StandardException(Code)(Java Doc)
protected boolean reflectionNeededForProjection()(Code)(Java Doc)
void replaceDefaults(TableDescriptor ttd, ResultColumnList tcl) throws StandardException(Code)(Java Doc)
void setChildResult(ResultSetNode childResult)(Code)(Java Doc)
public void setLevel(int level)(Code)(Java Doc)
boolean subqueryReferencesTarget(String name, boolean baseTable) throws StandardException(Code)(Java Doc)
public void updateBestPlanMap(short action, Object planKey) throws StandardException(Code)(Java Doc)
public int updateTargetLockMode()(Code)(Java Doc)

Fields inherited from org.apache.derby.impl.sql.compile.FromTable
final protected static short ADD_PLAN(Code)(Java Doc)
final protected static short LOAD_PLAN(Code)(Java Doc)
final protected static short REMOVE_PLAN(Code)(Java Doc)
AccessPathImpl bestAccessPath(Code)(Java Doc)
protected CostEstimate bestCostEstimate(Code)(Java Doc)
AccessPathImpl bestSortAvoidancePath(Code)(Java Doc)
TableName corrTableName(Code)(Java Doc)
String correlationName(Code)(Java Doc)
AccessPathImpl currentAccessPath(Code)(Java Doc)
int[] hashKeyColumns(Code)(Java Doc)
int initialCapacity(Code)(Java Doc)
int level(Code)(Java Doc)
float loadFactor(Code)(Java Doc)
int maxCapacity(Code)(Java Doc)
protected TableName origTableName(Code)(Java Doc)
int tableNumber(Code)(Java Doc)
Properties tableProperties(Code)(Java Doc)
AccessPathImpl trulyTheBestAccessPath(Code)(Java Doc)
protected String userSpecifiedJoinStrategy(Code)(Java Doc)

Methods inherited from org.apache.derby.impl.sql.compile.FromTable
public boolean LOJ_reorderable(int numTables) throws StandardException(Code)(Java Doc)
protected void assignCostEstimate(CostEstimate newCostEstimate)(Code)(Java Doc)
protected boolean canBeOrdered()(Code)(Java Doc)
public boolean considerSortAvoidancePath()(Code)(Java Doc)
public int convertAbsoluteToRelativeColumnPosition(int absolutePosition)(Code)(Java Doc)
protected boolean cursorTargetTable()(Code)(Java Doc)
void decrementLevel(int decrement)(Code)(Java Doc)
public CostEstimate estimateCost(OptimizablePredicateList predList, ConglomerateDescriptor cd, CostEstimate outerCost, Optimizer optimizer, RowOrdering rowOrdering) throws StandardException(Code)(Java Doc)
public boolean feasibleJoinStrategy(OptimizablePredicateList predList, Optimizer optimizer) throws StandardException(Code)(Java Doc)
public void fillInReferencedTableMap(JBitSet passedMap)(Code)(Java Doc)
public FromList flatten(ResultColumnList rcl, PredicateList outerPList, SubqueryList sql, GroupByList gbl) throws StandardException(Code)(Java Doc)
public boolean forUpdate()(Code)(Java Doc)
public String getBaseTableName()(Code)(Java Doc)
public AccessPath getBestAccessPath()(Code)(Java Doc)
public AccessPath getBestSortAvoidancePath()(Code)(Java Doc)
public String getCorrelationName()(Code)(Java Doc)
protected CostEstimate getCostEstimate(Optimizer optimizer)(Code)(Java Doc)
public AccessPath getCurrentAccessPath()(Code)(Java Doc)
public String getExposedName() throws StandardException(Code)(Java Doc)
public CostEstimate getFinalCostEstimate() throws StandardException(Code)(Java Doc)
protected FromTable getFromTableByName(String name, String schemaName, boolean exactMatch) throws StandardException(Code)(Java Doc)
public int getLevel()(Code)(Java Doc)
public String getName() throws StandardException(Code)(Java Doc)
public int getNumColumnsReturned()(Code)(Java Doc)
public TableName getOrigTableName()(Code)(Java Doc)
public Properties getProperties()(Code)(Java Doc)
public ResultColumnList getResultColumnsForList(TableName allTableName, ResultColumnList inputRcl, TableName tableName) throws StandardException(Code)(Java Doc)
public SchemaDescriptor getSchemaDescriptor() throws StandardException(Code)(Java Doc)
public SchemaDescriptor getSchemaDescriptor(TableName tableName) throws StandardException(Code)(Java Doc)
protected CostEstimate getScratchCostEstimate(Optimizer optimizer)(Code)(Java Doc)
public TableDescriptor getTableDescriptor()(Code)(Java Doc)
public TableName getTableName() throws StandardException(Code)(Java Doc)
public int getTableNumber()(Code)(Java Doc)
public AccessPath getTrulyTheBestAccessPath()(Code)(Java Doc)
String getUserSpecifiedJoinStrategy()(Code)(Java Doc)
public boolean hasTableNumber()(Code)(Java Doc)
public int[] hashKeyColumns()(Code)(Java Doc)
public void init(Object correlationName, Object tableProperties)(Code)(Java Doc)
public void initAccessPaths(Optimizer optimizer)(Code)(Java Doc)
public int initialCapacity()(Code)(Java Doc)
public boolean isBaseTable()(Code)(Java Doc)
public boolean isCoveringIndex(ConglomerateDescriptor cd) throws StandardException(Code)(Java Doc)
public boolean isFlattenableJoinNode()(Code)(Java Doc)
public boolean isMaterializable() throws StandardException(Code)(Java Doc)
public boolean isOneRowScan() throws StandardException(Code)(Java Doc)
public boolean isTargetTable()(Code)(Java Doc)
public boolean legalJoinOrder(JBitSet assignedTableMap)(Code)(Java Doc)
public float loadFactor()(Code)(Java Doc)
protected void markUpdatableByCursor(Vector updateColumns)(Code)(Java Doc)
public int maxCapacity(JoinStrategy joinStrategy, int maxMemoryPerTable) throws StandardException(Code)(Java Doc)
public boolean memoryUsageOK(double rowCount, int maxMemoryPerTable) throws StandardException(Code)(Java Doc)
public Optimizable modifyAccessPath(JBitSet outerTables) throws StandardException(Code)(Java Doc)
public boolean needsSpecialRCLBinding()(Code)(Java Doc)
public boolean nextAccessPath(Optimizer optimizer, OptimizablePredicateList predList, RowOrdering rowOrdering) throws StandardException(Code)(Java Doc)
public CostEstimate optimizeIt(Optimizer optimizer, OptimizablePredicateList predList, CostEstimate outerCost, RowOrdering rowOrdering) throws StandardException(Code)(Java Doc)
void optimizeSubqueries(DataDictionary dd, double rowCount) throws StandardException(Code)(Java Doc)
public void pullOptPredicates(OptimizablePredicateList optimizablePredicates) throws StandardException(Code)(Java Doc)
void pushExpressions(PredicateList predicateList) throws StandardException(Code)(Java Doc)
public boolean pushOptPredicate(OptimizablePredicate optimizablePredicate) throws StandardException(Code)(Java Doc)
public void rememberAsBest(int planType, Optimizer optimizer) throws StandardException(Code)(Java Doc)
public void rememberJoinStrategyAsBest(AccessPath ap)(Code)(Java Doc)
public void rememberSortAvoidancePath()(Code)(Java Doc)
protected void resetJoinStrategies(Optimizer optimizer)(Code)(Java Doc)
protected void setCostEstimate(CostEstimate newCostEstimate)(Code)(Java Doc)
public void setHashKeyColumns(int[] columnNumbers)(Code)(Java Doc)
public void setLevel(int level)(Code)(Java Doc)
public void setOrigTableName(TableName tableName)(Code)(Java Doc)
public void setProperties(Properties tableProperties)(Code)(Java Doc)
public void setTableNumber(int tableNumber)(Code)(Java Doc)
public void startOptimizing(Optimizer optimizer, RowOrdering rowOrdering)(Code)(Java Doc)
public boolean supportsMultipleInstantiations()(Code)(Java Doc)
protected void tellRowOrderingAboutConstantColumns(RowOrdering rowOrdering, OptimizablePredicateList predList)(Code)(Java Doc)
public String toString()(Code)(Java Doc)
public FromTable transformOuterJoins(ValueNode predicateTree, int numTables) throws StandardException(Code)(Java Doc)
public double uniqueJoin(OptimizablePredicateList predList) throws StandardException(Code)(Java Doc)
public void updateBestPlanMap(short action, Object planKey) throws StandardException(Code)(Java Doc)
public void verifyProperties(DataDictionary dDictionary) throws StandardException(Code)(Java Doc)

Fields inherited from org.apache.derby.impl.sql.compile.ResultSetNode
CostEstimate costEstimate(Code)(Java Doc)
boolean cursorTargetTable(Code)(Java Doc)
CostEstimate finalCostEstimate(Code)(Java Doc)
boolean insertSource(Code)(Java Doc)
Optimizer optimizer(Code)(Java Doc)
JBitSet referencedTableMap(Code)(Java Doc)
ResultColumnList resultColumns(Code)(Java Doc)
int resultSetNumber(Code)(Java Doc)
CostEstimate scratchCostEstimate(Code)(Java Doc)
boolean statementResultSet(Code)(Java Doc)

Methods inherited from org.apache.derby.impl.sql.compile.ResultSetNode
public JBitSet LOJgetReferencedTables(int numTables) throws StandardException(Code)(Java Doc)
public Visitable accept(Visitor v) throws StandardException(Code)(Java Doc)
public ResultSetNode addNewPredicate(Predicate predicate) throws StandardException(Code)(Java Doc)
public void assignResultSetNumber() throws StandardException(Code)(Java Doc)
public void bindExpressions(FromList fromListParam) throws StandardException(Code)(Java Doc)
public void bindExpressionsWithTables(FromList fromListParam) throws StandardException(Code)(Java Doc)
public ResultSetNode bindNonVTITables(DataDictionary dataDictionary, FromList fromListParam) throws StandardException(Code)(Java Doc)
public void bindResultColumns(FromList fromListParam) throws StandardException(Code)(Java Doc)
public void bindResultColumns(TableDescriptor targetTableDescriptor, FromVTI targetVTI, ResultColumnList targetColumnList, DMLStatementNode statement, FromList fromListParam) throws StandardException(Code)(Java Doc)
public void bindTargetExpressions(FromList fromListParam) throws StandardException(Code)(Java Doc)
public void bindUntypedNullsToResultColumns(ResultColumnList rcl) throws StandardException(Code)(Java Doc)
public ResultSetNode bindVTITables(FromList fromListParam) throws StandardException(Code)(Java Doc)
public ResultSetNode changeAccessPath() throws StandardException(Code)(Java Doc)
boolean columnTypesAndLengthsMatch() throws StandardException(Code)(Java Doc)
public ResultSetNode considerMaterialization(JBitSet outerTables) throws StandardException(Code)(Java Doc)
abstract void decrementLevel(int decrement)(Code)(Java Doc)
public void disablePrivilegeCollection()(Code)(Java Doc)
public ResultSetNode enhanceRCLForInsert(int numTargetColumns, int[] colMap, DataDictionary dataDictionary, TableDescriptor targetTD, FromVTI targetVTI) throws StandardException(Code)(Java Doc)
public ResultSetNode ensurePredicateList(int numTables) throws StandardException(Code)(Java Doc)
public void fillInReferencedTableMap(JBitSet passedMap)(Code)(Java Doc)
public boolean flattenableInFromSubquery(FromList fromList)(Code)(Java Doc)
ResultColumn genNewRCForInsert(TableDescriptor targetTD, FromVTI targetVTI, int columnNumber, DataDictionary dataDictionary) throws StandardException(Code)(Java Doc)
public NormalizeResultSetNode genNormalizeResultSetNode(ResultSetNode normalizeChild, boolean forUpdate) throws StandardException(Code)(Java Doc)
public ResultSetNode genProjectRestrict() throws StandardException(Code)(Java Doc)
protected ResultSetNode genProjectRestrict(int numTables) throws StandardException(Code)(Java Doc)
ResultSetNode genProjectRestrictForReordering() throws StandardException(Code)(Java Doc)
public void generateNormalizationResultSet(ActivationClassBuilder acb, MethodBuilder mb, int resultSetNumber, ResultDescription resultDescription) throws StandardException(Code)(Java Doc)
public void generateResultSet(ExpressionClassBuilder acb, MethodBuilder mb) throws StandardException(Code)(Java Doc)
public ResultColumnList getAllResultColumns(TableName allTableName) throws StandardException(Code)(Java Doc)
public CostEstimate getCostEstimate()(Code)(Java Doc)
FromTable getCursorTargetTable()(Code)(Java Doc)
public CostEstimate getFinalCostEstimate() throws StandardException(Code)(Java Doc)
public FromList getFromList() throws StandardException(Code)(Java Doc)
protected FromTable getFromTableByName(String name, String schemaName, boolean exactMatch) throws StandardException(Code)(Java Doc)
public ResultColumn getMatchingColumn(ColumnReference columnReference) throws StandardException(Code)(Java Doc)
protected CostEstimate getNewCostEstimate() throws StandardException(Code)(Java Doc)
protected Optimizer getOptimizer(OptimizableList optList, OptimizablePredicateList predList, DataDictionary dataDictionary, RequiredRowOrdering requiredRowOrdering) throws StandardException(Code)(Java Doc)
protected OptimizerImpl getOptimizerImpl()(Code)(Java Doc)
public JBitSet getReferencedTableMap()(Code)(Java Doc)
public ResultColumnList getResultColumns()(Code)(Java Doc)
public int getResultSetNumber()(Code)(Java Doc)
public boolean isNotExists()(Code)(Java Doc)
public boolean isOneRowResultSet() throws StandardException(Code)(Java Doc)
boolean isOrderedOn(ColumnReference[] crs, boolean permuteOrdering, Vector fbtVector) throws StandardException(Code)(Java Doc)
boolean isPossibleDistinctScan(Set distinctColumns)(Code)(Java Doc)
boolean isUpdatableCursor(DataDictionary dd) throws StandardException(Code)(Java Doc)
public ResultDescription makeResultDescription()(Code)(Java Doc)
ResultColumnDescriptor[] makeResultDescriptors(ExecutionContext ec)(Code)(Java Doc)
public boolean markAsCursorTargetTable()(Code)(Java Doc)
void markForDistinctScan()(Code)(Java Doc)
void markOrderingDependent()(Code)(Java Doc)
public void markStatementResultSet()(Code)(Java Doc)
public ResultSetNode modifyAccessPaths() throws StandardException(Code)(Java Doc)
public ResultSetNode modifyAccessPaths(PredicateList predList) throws StandardException(Code)(Java Doc)
void notCursorTargetTable()(Code)(Java Doc)
void notFlattenableJoin()(Code)(Java Doc)
final protected static int numDistinctAggregates(Vector aggregateVector)(Code)(Java Doc)
public ResultSetNode optimize(DataDictionary dataDictionary, PredicateList predicates, double outerRows) throws StandardException(Code)(Java Doc)
public ValueNode parseDefault(String defaultText) throws StandardException(Code)(Java Doc)
public boolean performMaterialization(JBitSet outerTables) throws StandardException(Code)(Java Doc)
public ResultSetNode preprocess(int numTables, GroupByList gbl, FromList fromList) throws StandardException(Code)(Java Doc)
public void printSubNodes(int depth)(Code)(Java Doc)
void projectResultColumns() throws StandardException(Code)(Java Doc)
void pushOrderByList(OrderByList orderByList)(Code)(Java Doc)
public boolean referencesTarget(String name, boolean baseTable) throws StandardException(Code)(Java Doc)
public void rejectParameters() throws StandardException(Code)(Java Doc)
public void rejectXMLValues() throws StandardException(Code)(Java Doc)
public void renameGeneratedResultNames() throws StandardException(Code)(Java Doc)
void replaceDefaults(TableDescriptor ttd, ResultColumnList tcl) throws StandardException(Code)(Java Doc)
boolean returnsAtMostOneRow()(Code)(Java Doc)
public void setInsertSource()(Code)(Java Doc)
public void setReferencedTableMap(JBitSet newRTM)(Code)(Java Doc)
public void setResultColumns(ResultColumnList newRCL)(Code)(Java Doc)
public void setResultToBooleanTrueNode(boolean onlyConvertAlls) throws StandardException(Code)(Java Doc)
void setTableConstructorTypes(ResultColumnList typeColumns) throws StandardException(Code)(Java Doc)
boolean subqueryReferencesTarget(String name, boolean baseTable) throws StandardException(Code)(Java Doc)
public String toString()(Code)(Java Doc)
public int updateTargetLockMode()(Code)(Java Doc)
public void verifySelectStarSubquery(FromList outerFromList, int subqueryType) throws StandardException(Code)(Java Doc)

Fields inherited from org.apache.derby.impl.sql.compile.QueryTreeNode
final public static int AUTOINCREMENT_CREATE_MODIFY(Code)(Java Doc)
final public static int AUTOINCREMENT_INC_INDEX(Code)(Java Doc)
final public static int AUTOINCREMENT_IS_AUTOINCREMENT_INDEX(Code)(Java Doc)
final public static int AUTOINCREMENT_START_INDEX(Code)(Java Doc)
boolean isPrivilegeCollectionRequired(Code)(Java Doc)

Methods inherited from org.apache.derby.impl.sql.compile.QueryTreeNode
public Visitable accept(Visitor v) throws StandardException(Code)(Java Doc)
public QueryTreeNode bind() throws StandardException(Code)(Java Doc)
public DataValueDescriptor convertDefaultNode(DataTypeDescriptor typeDescriptor) throws StandardException(Code)(Java Doc)
protected static void debugFlush()(Code)(Java Doc)
public static void debugPrint(String outputString)(Code)(Java Doc)
public void disablePrivilegeCollection()(Code)(Java Doc)
public String executeSchemaName()(Code)(Java Doc)
public String executeStatementName()(Code)(Java Doc)
public static String formatNodeString(String nodeString, int depth)(Code)(Java Doc)
public boolean foundString(String[] list, String search)(Code)(Java Doc)
public GeneratedClass generate(ByteArray ignored) throws StandardException(Code)(Java Doc)
protected void generate(ActivationClassBuilder acb, MethodBuilder mb) throws StandardException(Code)(Java Doc)
void generateAuthorizeCheck(ActivationClassBuilder acb, MethodBuilder mb, int sqlOperation)(Code)(Java Doc)
public int getBeginOffset()(Code)(Java Doc)
final protected ClassFactory getClassFactory()(Code)(Java Doc)
final protected CompilerContext getCompilerContext()(Code)(Java Doc)
final public ContextManager getContextManager()(Code)(Java Doc)
public Object getCursorInfo() throws StandardException(Code)(Java Doc)
final public DataDictionary getDataDictionary()(Code)(Java Doc)
final public DependencyManager getDependencyManager()(Code)(Java Doc)
public int getEndOffset()(Code)(Java Doc)
final public ExecutionFactory getExecutionFactory()(Code)(Java Doc)
final public GenericConstantActionFactory getGenericConstantActionFactory()(Code)(Java Doc)
protected int getIntProperty(String value, String key) throws StandardException(Code)(Java Doc)
final protected LanguageConnectionContext getLanguageConnectionContext()(Code)(Java Doc)
final public NodeFactory getNodeFactory()(Code)(Java Doc)
protected int getNodeType()(Code)(Java Doc)
public ConstantNode getNullNode(TypeId typeId, ContextManager cm) throws StandardException(Code)(Java Doc)
public DataTypeDescriptor[] getParameterTypes() throws StandardException(Code)(Java Doc)
public long getRowEstimate()(Code)(Java Doc)
public String getSPSName()(Code)(Java Doc)
final SchemaDescriptor getSchemaDescriptor(String schemaName) throws StandardException(Code)(Java Doc)
final SchemaDescriptor getSchemaDescriptor(String schemaName, boolean raiseError) throws StandardException(Code)(Java Doc)
protected int getStatementType()(Code)(Java Doc)
final protected TableDescriptor getTableDescriptor(String tableName, SchemaDescriptor schema) throws StandardException(Code)(Java Doc)
final protected TypeCompiler getTypeCompiler(TypeId typeId)(Code)(Java Doc)
public void init(Object arg1) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3, Object arg4) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7, Object arg8) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7, Object arg8, Object arg9) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7, Object arg8, Object arg9, Object arg10) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7, Object arg8, Object arg9, Object arg10, Object arg11) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7, Object arg8, Object arg9, Object arg10, Object arg11, Object arg12) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7, Object arg8, Object arg9, Object arg10, Object arg11, Object arg12, Object arg13) throws StandardException(Code)(Java Doc)
public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7, Object arg8, Object arg9, Object arg10, Object arg11, Object arg12, Object arg13, Object arg14) throws StandardException(Code)(Java Doc)
public boolean isAtomic() throws StandardException(Code)(Java Doc)
protected boolean isInstanceOf(int nodeType)(Code)(Java Doc)
public boolean isPrivilegeCollectionRequired()(Code)(Java Doc)
final boolean isSessionSchema(SchemaDescriptor sd)(Code)(Java Doc)
final boolean isSessionSchema(String schemaName)(Code)(Java Doc)
public ConstantAction makeConstantAction() throws StandardException(Code)(Java Doc)
public ResultDescription makeResultDescription() throws StandardException(Code)(Java Doc)
public TableName makeTableName(String schemaName, String flatName) throws StandardException(Code)(Java Doc)
public boolean needsSavepoint()(Code)(Java Doc)
protected String nodeHeader()(Code)(Java Doc)
public QueryTreeNode optimize() throws StandardException(Code)(Java Doc)
public static QueryTreeNode parseQueryText(CompilerContext compilerContext, String queryText, Object[] paramDefaults, LanguageConnectionContext lcc) throws StandardException(Code)(Java Doc)
public void printLabel(int depth, String label)(Code)(Java Doc)
public void printSubNodes(int depth)(Code)(Java Doc)
public boolean referencesSessionSchema() throws StandardException(Code)(Java Doc)
public TableName resolveTableToSynonym(TableName tabName) throws StandardException(Code)(Java Doc)
public void setBeginOffset(int beginOffset)(Code)(Java Doc)
public void setContextManager(ContextManager cm)(Code)(Java Doc)
public void setEndOffset(int endOffset)(Code)(Java Doc)
public void setNodeType(int nodeType)(Code)(Java Doc)
public void setRefActionInfo(long fkIndexConglomId, int[] fkColArray, String parentResultSetId, boolean dependentScan)(Code)(Java Doc)
public String toString()(Code)(Java Doc)
public void treePrint()(Code)(Java Doc)
public void treePrint(int depth)(Code)(Java Doc)
String verifyClassExist(String javaClassName, boolean convertCase) throws StandardException(Code)(Java Doc)

Methods inherited from java.lang.Object
native protected Object clone() throws CloneNotSupportedException(Code)(Java Doc)
public boolean equals(Object obj)(Code)(Java Doc)
protected void finalize() throws Throwable(Code)(Java Doc)
final native public Class getClass()(Code)(Java Doc)
native public int hashCode()(Code)(Java Doc)
final native public void notify()(Code)(Java Doc)
final native public void notifyAll()(Code)(Java Doc)
public String toString()(Code)(Java Doc)
final native public void wait(long timeout) throws InterruptedException(Code)(Java Doc)
final public void wait(long timeout, int nanos) throws InterruptedException(Code)(Java Doc)
final public void wait() throws InterruptedException(Code)(Java Doc)

www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.