Java Doc for FromTable.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

All known Subclasses:   org.apache.derby.impl.sql.compile.FromVTI,  org.apache.derby.impl.sql.compile.CurrentOfNode,  org.apache.derby.impl.sql.compile.FromBaseTable,  org.apache.derby.impl.sql.compile.SingleChildResultSetNode,  org.apache.derby.impl.sql.compile.FromSubquery,  org.apache.derby.impl.sql.compile.IndexToBaseRowNode,  org.apache.derby.impl.sql.compile.TableOperatorNode,  org.apache.derby.impl.sql.compile.RowResultSetNode,
FromTable
abstract class FromTable extends ResultSetNode implements Optimizable(Code)
A FromTable represents a table in the FROM clause of a DML statement. It can be either a base table, a subquery or a project restrict.
See Also:   FromBaseTable
See Also:   FromSubquery
See Also:   ProjectRestrictNode
author:
   Jeff Lichtman


Field Summary
final protected static  shortADD_PLAN
    
final protected static  shortLOAD_PLAN
    
final protected static  shortREMOVE_PLAN
     Operations that can be performed on bestPlanMap.
 AccessPathImplbestAccessPath
    
protected  CostEstimatebestCostEstimate
    
 AccessPathImplbestSortAvoidancePath
    
 TableNamecorrTableName
    
 StringcorrelationName
    
 AccessPathImplcurrentAccessPath
    
 int[]hashKeyColumns
    
 intinitialCapacity
    
 intlevel
    
 floatloadFactor
    
 intmaxCapacity
    
protected  TableNameorigTableName
    
 inttableNumber
    
 PropertiestableProperties
    
 AccessPathImpltrulyTheBestAccessPath
    
protected  StringuserSpecifiedJoinStrategy
    


Method Summary
public  booleanLOJ_reorderable(int numTables)
     no LOJ reordering for this FromTable.
protected  voidassignCostEstimate(CostEstimate newCostEstimate)
     Assign the cost estimate in this node to the given cost estimate.
protected  booleancanBeOrdered()
    
public  booleanconsiderSortAvoidancePath()
    
public  intconvertAbsoluteToRelativeColumnPosition(int absolutePosition)
    
protected  booleancursorTargetTable()
     Is this a table that has a FOR UPDATE clause.
 voiddecrementLevel(int decrement)
     Decrement (query block) level (0-based) for this FromTable.
public  CostEstimateestimateCost(OptimizablePredicateList predList, ConglomerateDescriptor cd, CostEstimate outerCost, Optimizer optimizer, RowOrdering rowOrdering)
    
public  booleanfeasibleJoinStrategy(OptimizablePredicateList predList, Optimizer optimizer)
    
public  voidfillInReferencedTableMap(JBitSet passedMap)
     Fill the referencedTableMap with this ResultSetNode.
public  FromListflatten(ResultColumnList rcl, PredicateList outerPList, SubqueryList sql, GroupByList gbl)
     Flatten this FromTable into the outer query block.
public  booleanforUpdate()
    
public  StringgetBaseTableName()
    
public  AccessPathgetBestAccessPath()
    
public  AccessPathgetBestSortAvoidancePath()
    
public  StringgetCorrelationName()
     Get this table's correlation name, if any.
protected  CostEstimategetCostEstimate(Optimizer optimizer)
    
public  AccessPathgetCurrentAccessPath()
    
public  StringgetExposedName()
     Get the exposed name for this table, which is the name that can be used to refer to it in the rest of the query.
public  CostEstimategetFinalCostEstimate()
     Get the final CostEstimate for this FromTable.
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.
public  intgetLevel()
     Get the (query block) level (0-based) for this FromTable.
public  StringgetName()
    
public  intgetNumColumnsReturned()
    
public  TableNamegetOrigTableName()
     Gets the original or unbound table name for this FromTable.
public  PropertiesgetProperties()
    
public  ResultColumnListgetResultColumnsForList(TableName allTableName, ResultColumnList inputRcl, TableName tableName)
     Return a ResultColumnList with all of the columns in this table.
public  SchemaDescriptorgetSchemaDescriptor()
     Get a schema descriptor for the given table.
public  SchemaDescriptorgetSchemaDescriptor(TableName tableName)
     Get a schema descriptor for the given table.
protected  CostEstimategetScratchCostEstimate(Optimizer optimizer)
    
public  TableDescriptorgetTableDescriptor()
    
public  TableNamegetTableName()
     Return a TableName node representing this FromTable.
public  intgetTableNumber()
    
public  AccessPathgetTrulyTheBestAccessPath()
    
 StringgetUserSpecifiedJoinStrategy()
     Return the user specified join strategy, if any for this table.
public  booleanhasTableNumber()
    
public  int[]hashKeyColumns()
    
public  voidinit(Object correlationName, Object tableProperties)
     Initializer for a table in a FROM list.
public  voidinitAccessPaths(Optimizer optimizer)
    
public  intinitialCapacity()
    
public  booleanisBaseTable()
    
public  booleanisCoveringIndex(ConglomerateDescriptor cd)
    
public  booleanisFlattenableJoinNode()
     Is this FromTable a JoinNode which can be flattened into the parents FromList.
public  booleanisMaterializable()
    
public  booleanisOneRowScan()
    
public  booleanisTargetTable()
    
public  booleanlegalJoinOrder(JBitSet assignedTableMap)
    
public  floatloadFactor()
    
protected  voidmarkUpdatableByCursor(Vector updateColumns)
     Mark as updatable all the columns in the result column list of this FromBaseTable that match the columns in the given update column list.
public  intmaxCapacity(JoinStrategy joinStrategy, int maxMemoryPerTable)
    
public  booleanmemoryUsageOK(double rowCount, int maxMemoryPerTable)
    
public  OptimizablemodifyAccessPath(JBitSet outerTables)
    
public  booleanneedsSpecialRCLBinding()
    
public  booleannextAccessPath(Optimizer optimizer, OptimizablePredicateList predList, RowOrdering rowOrdering)
    
public  CostEstimateoptimizeIt(Optimizer optimizer, OptimizablePredicateList predList, CostEstimate outerCost, RowOrdering rowOrdering)
    
 voidoptimizeSubqueries(DataDictionary dd, double rowCount)
     Optimize any subqueries that haven't been optimized any where else.
public  voidpullOptPredicates(OptimizablePredicateList optimizablePredicates)
    
 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  voidrememberJoinStrategyAsBest(AccessPath ap)
    
public  voidrememberSortAvoidancePath()
    
protected  voidresetJoinStrategies(Optimizer optimizer)
     This method is called when this table is placed in a potential join order, or when a new conglomerate is being considered.
protected  voidsetCostEstimate(CostEstimate newCostEstimate)
     Set the cost estimate in this node to the given cost estimate.
public  voidsetHashKeyColumns(int[] columnNumbers)
    
public  voidsetLevel(int level)
     Set the (query block) level (0-based) for this FromTable.
public  voidsetOrigTableName(TableName tableName)
     Sets the original or unbound table name for this FromTable.
public  voidsetProperties(Properties tableProperties)
    
public  voidsetTableNumber(int tableNumber)
     Set the table # for this table.
public  voidstartOptimizing(Optimizer optimizer, RowOrdering rowOrdering)
    
public  booleansupportsMultipleInstantiations()
    
protected  voidtellRowOrderingAboutConstantColumns(RowOrdering rowOrdering, OptimizablePredicateList predList)
     Tell the given RowOrdering about any columns that are constant due to their being equality comparisons with constant expressions.
public  StringtoString()
     Convert this object to a String.
public  FromTabletransformOuterJoins(ValueNode predicateTree, int numTables)
     Transform any Outer Join into an Inner Join where applicable.
public  doubleuniqueJoin(OptimizablePredicateList predList)
    
public  voidupdateBestPlanMap(short action, Object planKey)
    
public  voidverifyProperties(DataDictionary dDictionary)
    

Field Detail
ADD_PLAN
final protected static short ADD_PLAN(Code)



LOAD_PLAN
final protected static short LOAD_PLAN(Code)



REMOVE_PLAN
final protected static short REMOVE_PLAN(Code)
Operations that can be performed on bestPlanMap.



bestAccessPath
AccessPathImpl bestAccessPath(Code)



bestCostEstimate
protected CostEstimate bestCostEstimate(Code)



bestSortAvoidancePath
AccessPathImpl bestSortAvoidancePath(Code)



corrTableName
TableName corrTableName(Code)



correlationName
String correlationName(Code)



currentAccessPath
AccessPathImpl currentAccessPath(Code)



hashKeyColumns
int[] hashKeyColumns(Code)



initialCapacity
int initialCapacity(Code)



level
int level(Code)



loadFactor
float loadFactor(Code)



maxCapacity
int maxCapacity(Code)



origTableName
protected TableName origTableName(Code)
the original unbound table name



tableNumber
int tableNumber(Code)



tableProperties
Properties tableProperties(Code)



trulyTheBestAccessPath
AccessPathImpl trulyTheBestAccessPath(Code)



userSpecifiedJoinStrategy
protected String userSpecifiedJoinStrategy(Code)





Method Detail
LOJ_reorderable
public boolean LOJ_reorderable(int numTables) throws StandardException(Code)
no LOJ reordering for this FromTable.



assignCostEstimate
protected void assignCostEstimate(CostEstimate newCostEstimate)(Code)
Assign the cost estimate in this node to the given cost estimate.



canBeOrdered
protected boolean canBeOrdered()(Code)
Most Optimizables cannot be ordered



considerSortAvoidancePath
public boolean considerSortAvoidancePath()(Code)

See Also:   Optimizable.considerSortAvoidancePath
See Also:   



convertAbsoluteToRelativeColumnPosition
public int convertAbsoluteToRelativeColumnPosition(int absolutePosition)(Code)

See Also:   Optimizable.convertAbsoluteToRelativeColumnPosition
See Also:   



cursorTargetTable
protected boolean cursorTargetTable()(Code)
Is this a table that has a FOR UPDATE clause. Overridden by FromBaseTable. true/false



decrementLevel
void decrementLevel(int decrement)(Code)
Decrement (query block) level (0-based) for this FromTable. This is useful when flattening a subquery.
Parameters:
  decrement - The amount to decrement by.



estimateCost
public CostEstimate estimateCost(OptimizablePredicateList predList, ConglomerateDescriptor cd, CostEstimate outerCost, Optimizer optimizer, RowOrdering rowOrdering) throws StandardException(Code)

See Also:   Optimizable.estimateCost
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



fillInReferencedTableMap
public void fillInReferencedTableMap(JBitSet passedMap)(Code)
Fill the referencedTableMap with this ResultSetNode.
Parameters:
  passedMap - The table map to fill in.



flatten
public FromList flatten(ResultColumnList rcl, PredicateList outerPList, SubqueryList sql, GroupByList gbl) throws StandardException(Code)
Flatten this FromTable into the outer query block. The steps in flattening are: o Mark all ResultColumns as redundant, so that they are "skipped over" at generate(). o Append the wherePredicates to the outer list. o Return the fromList so that the caller will merge the 2 lists
Parameters:
  rcl - The RCL from the outer query
Parameters:
  outerPList - PredicateList to append wherePredicates to.
Parameters:
  sql - The SubqueryList from the outer query
Parameters:
  gbl - The group by list, if any FromList The fromList from the underlying SelectNode.
exception:
  StandardException - Thrown on error



forUpdate
public boolean forUpdate()(Code)

See Also:   Optimizable.forUpdate
See Also:   



getBaseTableName
public String getBaseTableName()(Code)

See Also:   Optimizable.getBaseTableName
See Also:   



getBestAccessPath
public AccessPath getBestAccessPath()(Code)

See Also:   Optimizable.getBestAccessPath
See Also:   



getBestSortAvoidancePath
public AccessPath getBestSortAvoidancePath()(Code)

See Also:   Optimizable.getBestSortAvoidancePath
See Also:   



getCorrelationName
public String getCorrelationName()(Code)
Get this table's correlation name, if any.



getCostEstimate
protected CostEstimate getCostEstimate(Optimizer optimizer)(Code)



getCurrentAccessPath
public AccessPath getCurrentAccessPath()(Code)

See Also:   Optimizable.getCurrentAccessPath
See Also:   



getExposedName
public String getExposedName() throws StandardException(Code)
Get the exposed name for this table, which is the name that can be used to refer to it in the rest of the query. The exposed name of this table.
exception:
  StandardException - Thrown on error



getFinalCostEstimate
public CostEstimate getFinalCostEstimate() throws StandardException(Code)
Get the final CostEstimate for this FromTable. The final CostEstimate for this FromTable, which isthe costEstimate of trulyTheBestAccessPath if there is one.If there's no trulyTheBestAccessPath for this node, thenwe just return the value stored in costEstimate as a default.



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



getLevel
public int getLevel()(Code)
Get the (query block) level (0-based) for this FromTable. int The query block level for this FromTable.



getName
public String getName() throws StandardException(Code)

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



getNumColumnsReturned
public int getNumColumnsReturned()(Code)

See Also:   Optimizable.getNumColumnsReturned



getOrigTableName
public TableName getOrigTableName()(Code)
Gets the original or unbound table name for this FromTable. The tableName field can be changed due to synonym resolution. Use this method to retrieve the actual unbound tablename. TableName the original or unbound tablename



getProperties
public Properties getProperties()(Code)

See Also:   Optimizable.getProperties
See Also:   



getResultColumnsForList
public ResultColumnList getResultColumnsForList(TableName allTableName, ResultColumnList inputRcl, TableName tableName) throws StandardException(Code)
Return a ResultColumnList with all of the columns in this table. (Used in expanding '*'s.) NOTE: Since this method is for expanding a "*" in the SELECT list, ResultColumn.expression will be a ColumnReference.
Parameters:
  allTableName - The qualifier on the "*" ResultColumnList List of result columns from this table.
exception:
  StandardException - Thrown on error



getSchemaDescriptor
public SchemaDescriptor getSchemaDescriptor() throws StandardException(Code)
Get a schema descriptor for the given table. Uses this.corrTableName. Schema Descriptor
exception:
  StandardException - throws on schema namethat doesn't exist



getSchemaDescriptor
public SchemaDescriptor getSchemaDescriptor(TableName tableName) throws StandardException(Code)
Get a schema descriptor for the given table.
Parameters:
  tableName - the table name Schema Descriptor
exception:
  StandardException - throws on schema namethat doesn't exist



getScratchCostEstimate
protected CostEstimate getScratchCostEstimate(Optimizer optimizer)(Code)



getTableDescriptor
public TableDescriptor getTableDescriptor()(Code)

See Also:   Optimizable.getTableDescriptor
See Also:   



getTableName
public TableName getTableName() throws StandardException(Code)
Return a TableName node representing this FromTable. Expect this to be overridden (and used) by subclasses that may set correlationName to null. a TableName node representing this FromTable.
exception:
  StandardException - Thrown on error



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.



hasTableNumber
public boolean hasTableNumber()(Code)

See Also:   Optimizable.hasTableNumber
See Also:   



hashKeyColumns
public int[] hashKeyColumns()(Code)

See Also:   Optimizable.hashKeyColumns
See Also:   



init
public void init(Object correlationName, Object tableProperties)(Code)
Initializer for a table in a FROM list.
Parameters:
  correlationName - The correlation name
Parameters:
  tableProperties - Properties list associated with the table



initAccessPaths
public void initAccessPaths(Optimizer optimizer)(Code)

See Also:   Optimizable.initAccessPaths



initialCapacity
public int initialCapacity()(Code)

See Also:   Optimizable.initialCapacity
See Also:   



isBaseTable
public boolean isBaseTable()(Code)

See Also:   Optimizable.isBaseTable
See Also:   



isCoveringIndex
public boolean isCoveringIndex(ConglomerateDescriptor cd) throws StandardException(Code)

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



isFlattenableJoinNode
public boolean isFlattenableJoinNode()(Code)
Is this FromTable a JoinNode which can be flattened into the parents FromList. boolean Whether or not this FromTable can be flattened.



isMaterializable
public boolean isMaterializable() throws StandardException(Code)

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



isOneRowScan
public boolean isOneRowScan() throws StandardException(Code)

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



isTargetTable
public boolean isTargetTable()(Code)

See Also:   Optimizable.isTargetTable



legalJoinOrder
public boolean legalJoinOrder(JBitSet assignedTableMap)(Code)

See Also:   Optimizable.legalJoinOrder



loadFactor
public float loadFactor()(Code)

See Also:   Optimizable.loadFactor
See Also:   



markUpdatableByCursor
protected void markUpdatableByCursor(Vector updateColumns)(Code)
Mark as updatable all the columns in the result column list of this FromBaseTable that match the columns in the given update column list. If the list is null, it means all the columns are updatable.
Parameters:
  updateColumns - A Vector representing the columnsthat can be updated.



maxCapacity
public int maxCapacity(JoinStrategy joinStrategy, int maxMemoryPerTable) throws StandardException(Code)

See Also:   Optimizable.maxCapacity
See Also:   



memoryUsageOK
public boolean memoryUsageOK(double rowCount, int maxMemoryPerTable) throws StandardException(Code)

See Also:   Optimizable.memoryUsageOK
See Also:   



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

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



needsSpecialRCLBinding
public boolean needsSpecialRCLBinding()(Code)



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

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



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

See Also:   org.apache.derby.iapi.sql.compile.Optimizable.optimizeIt
exception:
  StandardException - Thrown on error



optimizeSubqueries
void optimizeSubqueries(DataDictionary dd, double rowCount) throws StandardException(Code)
Optimize any subqueries that haven't been optimized any where else. This is useful for a RowResultSetNode as a derived table because it doesn't get optimized otherwise.
exception:
  StandardException - Thrown on error



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

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



pushExpressions
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:   org.apache.derby.iapi.sql.compile.Optimizable.pushOptPredicate
exception:
  StandardException - Thrown on error



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

See Also:   Optimizable.rememberAsBest
See Also:   



rememberJoinStrategyAsBest
public void rememberJoinStrategyAsBest(AccessPath ap)(Code)

See Also:   Optimizable.rememberJoinStrategyAsBest
See Also:   



rememberSortAvoidancePath
public void rememberSortAvoidancePath()(Code)

See Also:   Optimizable.rememberSortAvoidancePath
See Also:   



resetJoinStrategies
protected void resetJoinStrategies(Optimizer optimizer)(Code)
This method is called when this table is placed in a potential join order, or when a new conglomerate is being considered. Set this join strategy number to 0 to indicate that no join strategy has been considered for this table yet.



setCostEstimate
protected void setCostEstimate(CostEstimate newCostEstimate)(Code)
Set the cost estimate in this node to the given cost estimate.



setHashKeyColumns
public void setHashKeyColumns(int[] columnNumbers)(Code)

See Also:   Optimizable.setHashKeyColumns
See Also:   



setLevel
public void setLevel(int level)(Code)
Set the (query block) level (0-based) for this FromTable.
Parameters:
  level - The query block level for this FromTable.



setOrigTableName
public void setOrigTableName(TableName tableName)(Code)
Sets the original or unbound table name for this FromTable.
Parameters:
  tableName - the unbound table name



setProperties
public void setProperties(Properties tableProperties)(Code)

See Also:   Optimizable.setProperties
See Also:   



setTableNumber
public void setTableNumber(int tableNumber)(Code)
Set the table # for this table.
Parameters:
  tableNumber - The table # for this table.



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

See Also:   Optimizable.startOptimizing
See Also:   



supportsMultipleInstantiations
public boolean supportsMultipleInstantiations()(Code)

See Also:   Optimizable.supportsMultipleInstantiations
See Also:   



tellRowOrderingAboutConstantColumns
protected void tellRowOrderingAboutConstantColumns(RowOrdering rowOrdering, OptimizablePredicateList predList)(Code)
Tell the given RowOrdering about any columns that are constant due to their being equality comparisons with constant expressions.



toString
public String toString()(Code)
Convert this object to a String. See comments in QueryTreeNode.java for how this should be done for tree printing. This object as a String



transformOuterJoins
public FromTable transformOuterJoins(ValueNode predicateTree, int numTables) throws StandardException(Code)
Transform any Outer Join into an Inner Join where applicable. (Based on the existence of a null intolerant predicate on the inner table.)
Parameters:
  predicateTree - The predicate tree for the query block The new tree top (OuterJoin or InnerJoin).
exception:
  StandardException - Thrown on error



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

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



updateBestPlanMap
public void updateBestPlanMap(short action, Object planKey) throws StandardException(Code)

See Also:   Optimizable.updateBestPlanMap
See Also:   



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.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.