0j P Q R S TU VW X Y Z [\ ] ^ _ ` a bc d e fg h i Lj Lk lm fn Lop q r s Lt Lu v w x y z { f| } ~ ~         H H  HP H K K H Kh f   T f   f fh  b       f f   kP  k       f    @(  A     L  b       f                tablePropertiesLjava/util/Properties;correlationNameLjava/lang/String; corrTableName-Lorg/apache/derby/impl/sql/compile/TableName; tableNumberIlevelhashKeyColumns[IinitialCapacity loadFactorF maxCapacitycurrentAccessPath2Lorg/apache/derby/impl/sql/compile/AccessPathImpl;bestAccessPathbestSortAvoidancePathtrulyTheBestAccessPathjoinStrategyNumberuserSpecifiedJoinStrategybestCostEstimate0Lorg/apache/derby/iapi/sql/compile/CostEstimate;refCols4Lorg/apache/derby/iapi/services/io/FormatableBitSet; perRowUsageDconsiderSortAvoidancePathZ bestPlanMapLjava/util/HashMap; REMOVE_PLANS ConstantValueADD_PLAN LOAD_PLAN origTableName()VCodeinit'(Ljava/lang/Object;Ljava/lang/Object;)VgetCorrelationName()Ljava/lang/String; optimizeIt(Lorg/apache/derby/iapi/sql/compile/Optimizer;Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/compile/CostEstimate;Lorg/apache/derby/iapi/sql/compile/RowOrdering;)Lorg/apache/derby/iapi/sql/compile/CostEstimate; ExceptionsnextAccessPath(Lorg/apache/derby/iapi/sql/compile/Optimizer;Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/compile/RowOrdering;)Z canBeOrdered()ZgetCurrentAccessPath0()Lorg/apache/derby/iapi/sql/compile/AccessPath;getBestAccessPathgetBestSortAvoidancePathgetTrulyTheBestAccessPathrememberSortAvoidancePathrememberJoinStrategyAsBest1(Lorg/apache/derby/iapi/sql/compile/AccessPath;)VgetTableDescriptor8()Lorg/apache/derby/iapi/sql/dictionary/TableDescriptor;pushOptPredicate;(Lorg/apache/derby/iapi/sql/compile/OptimizablePredicate;)ZpullOptPredicates?(Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;)VmodifyAccessPathU(Lorg/apache/derby/iapi/util/JBitSet;)Lorg/apache/derby/iapi/sql/compile/Optimizable;isCoveringIndex@(Lorg/apache/derby/iapi/sql/dictionary/ConglomerateDescriptor;)Z getProperties()Ljava/util/Properties; setProperties(Ljava/util/Properties;)VverifyProperties8(Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;)VgetNamegetBaseTableName'convertAbsoluteToRelativeColumnPosition(I)IupdateBestPlanMap(SLjava/lang/Object;)VrememberAsBest1(ILorg/apache/derby/iapi/sql/compile/Optimizer;)VstartOptimizing_(Lorg/apache/derby/iapi/sql/compile/Optimizer;Lorg/apache/derby/iapi/sql/compile/RowOrdering;)VresetJoinStrategies0(Lorg/apache/derby/iapi/sql/compile/Optimizer;)V estimateCost7(Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/dictionary/ConglomerateDescriptor;Lorg/apache/derby/iapi/sql/compile/CostEstimate;Lorg/apache/derby/iapi/sql/compile/Optimizer;Lorg/apache/derby/iapi/sql/compile/RowOrdering;)Lorg/apache/derby/iapi/sql/compile/CostEstimate;getFinalCostEstimate2()Lorg/apache/derby/iapi/sql/compile/CostEstimate; isBaseTablehasLargeObjectColumnsisMaterializablesupportsMultipleInstantiationsgetTableNumber()IhasTableNumber forUpdate()F4(Lorg/apache/derby/iapi/sql/compile/JoinStrategy;I)IgetPerRowUsage()D()[IsetHashKeyColumns([I)VfeasibleJoinStrategyl(Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/compile/Optimizer;)Z memoryUsageOK(DI)ZisJoinColumnForRightOuterJoin3(Lorg/apache/derby/impl/sql/compile/ResultColumn;)VlegalJoinOrder'(Lorg/apache/derby/iapi/util/JBitSet;)ZgetNumColumnsReturned isTargetTable isOneRowScaninitAccessPaths uniqueJoin?(Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;)D getRefCols6()Lorg/apache/derby/iapi/services/io/FormatableBitSet;getUserSpecifiedJoinStrategycursorTargetTablegetCostEstimate_(Lorg/apache/derby/iapi/sql/compile/Optimizer;)Lorg/apache/derby/iapi/sql/compile/CostEstimate;getScratchCostEstimatesetCostEstimate3(Lorg/apache/derby/iapi/sql/compile/CostEstimate;)VassignCostEstimatetoStringgetResultColumnsForList(Lorg/apache/derby/impl/sql/compile/TableName;Lorg/apache/derby/impl/sql/compile/ResultColumnList;Lorg/apache/derby/impl/sql/compile/TableName;)Lorg/apache/derby/impl/sql/compile/ResultColumnList;pushExpressions4(Lorg/apache/derby/impl/sql/compile/PredicateList;)VgetExposedNamesetTableNumber(I)V getTableName/()Lorg/apache/derby/impl/sql/compile/TableName;setLevelgetLeveldecrementLevelgetSchemaDescriptor9()Lorg/apache/derby/iapi/sql/dictionary/SchemaDescriptor;f(Lorg/apache/derby/impl/sql/compile/TableName;)Lorg/apache/derby/iapi/sql/dictionary/SchemaDescriptor;getFromTableByNameT(Ljava/lang/String;Ljava/lang/String;Z)Lorg/apache/derby/impl/sql/compile/FromTable;isFlattenableJoinNodeLOJ_reorderable(I)ZtransformOuterJoins](Lorg/apache/derby/impl/sql/compile/ValueNode;I)Lorg/apache/derby/impl/sql/compile/FromTable;fillInReferencedTableMap'(Lorg/apache/derby/iapi/util/JBitSet;)VmarkUpdatableByCursor(Ljava/util/Vector;)Vflatten(Lorg/apache/derby/impl/sql/compile/ResultColumnList;Lorg/apache/derby/impl/sql/compile/PredicateList;Lorg/apache/derby/impl/sql/compile/SubqueryList;Lorg/apache/derby/impl/sql/compile/GroupByList;Lorg/apache/derby/impl/sql/compile/ValueNode;)Lorg/apache/derby/impl/sql/compile/FromList;optimizeSubqueries9(Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;D)V#tellRowOrderingAboutConstantColumnsn(Lorg/apache/derby/iapi/sql/compile/RowOrdering;Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;)VneedsSpecialRCLBindingsetOrigTableName0(Lorg/apache/derby/impl/sql/compile/TableName;)VgetOrigTableName java/lang/String java/util/Properties ;org/apache/derby/iapi/sql/dictionary/ConglomerateDescriptor  %& ()    HI   %    .org/apache/derby/iapi/sql/compile/JoinStrategy  42Y56    JK         joinStrategy  hashInitialCapacity 42Y59  hashLoadFactor java/lang/NumberFormatException42Y5842Y60hashMaxCapacity42Y6142Y44 0   java/util/HashMap0org/apache/derby/impl/sql/compile/AccessPathImpl+org/apache/derby/iapi/sql/compile/Optimizer   5org/apache/derby/impl/sql/compile/ProjectRestrictNode  !-org/apache/derby/iapi/sql/compile/Optimizable "#  $% &' ( )* + ,- ./.org/apache/derby/impl/sql/compile/ResultColumn 0 123 456 79org/apache/derby/impl/sql/compile/HasCorrelatedCRsVisitor 89 :  ; $ <=> ?? @A B2 C D EF  G H I J &)K L MN O PQ RST UV2org/apache/derby/impl/sql/compile/ResultColumnList UW+org/apache/derby/impl/sql/compile/ValueNode X 8: 8YZ [2 DE\ ]^+org/apache/derby/impl/sql/compile/Predicate _` abc def g hi +org/apache/derby/impl/sql/compile/FromTable/org/apache/derby/impl/sql/compile/ResultSetNode-org/apache/derby/iapi/error/StandardExceptiongetDataDictionary7()Lorg/apache/derby/iapi/sql/dictionary/DataDictionary; costEstimate.org/apache/derby/iapi/sql/compile/CostEstimaterowCount,org/apache/derby/iapi/sql/compile/AccessPathgetJoinStrategy2()Lorg/apache/derby/iapi/sql/compile/JoinStrategy;8(Lorg/apache/derby/iapi/sql/compile/Optimizable;Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/dictionary/ConglomerateDescriptor;Lorg/apache/derby/iapi/sql/compile/CostEstimate;Lorg/apache/derby/iapi/sql/compile/Optimizer;Lorg/apache/derby/iapi/sql/compile/CostEstimate;)V considerCost(Lorg/apache/derby/iapi/sql/compile/Optimizable;Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/compile/CostEstimate;Lorg/apache/derby/iapi/sql/compile/CostEstimate;)VgetNumberOfJoinStrategiessetJoinStrategy3(Lorg/apache/derby/iapi/sql/compile/JoinStrategy;)VD(Ljava/lang/String;)Lorg/apache/derby/iapi/sql/compile/JoinStrategy; newExceptiong(Ljava/lang/String;Ljava/lang/Object;Ljava/lang/Object;)Lorg/apache/derby/iapi/error/StandardException;3(I)Lorg/apache/derby/iapi/sql/compile/JoinStrategy;trace(IIIDLjava/lang/Object;)V getOptimizer/()Lorg/apache/derby/iapi/sql/compile/Optimizer;keys()Ljava/util/Enumeration;java/util/EnumerationhasMoreElements nextElement()Ljava/lang/Object;get&(Ljava/lang/Object;)Ljava/lang/Object;equals(Ljava/lang/Object;)Z%org/apache/derby/iapi/util/StringUtilSQLToUpperCase&(Ljava/lang/String;)Ljava/lang/String;getIntProperty'(Ljava/lang/String;Ljava/lang/String;)IvalueOf(I)Ljava/lang/String;U(Ljava/lang/String;Ljava/lang/Object;)Lorg/apache/derby/iapi/error/StandardException;java/lang/Float parseFloat(Ljava/lang/String;)Fremovesizecopyput8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;getChildResult3()Lorg/apache/derby/impl/sql/compile/ResultSetNode;getConglomerateDescriptor?()Lorg/apache/derby/iapi/sql/dictionary/ConglomerateDescriptor;initializeAccessPathNamen(Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;Lorg/apache/derby/iapi/sql/dictionary/TableDescriptor;)VsetCost(DDD)V-org/apache/derby/iapi/sql/compile/RowOrderingaddUnorderedOptimizable2(Lorg/apache/derby/iapi/sql/compile/Optimizable;)VfinalCostEstimate resultColumns4Lorg/apache/derby/impl/sql/compile/ResultColumnList; elementAt4(I)Lorg/apache/derby/impl/sql/compile/QueryTreeNode; isReferencedgetType2()Lorg/apache/derby/iapi/types/DataTypeDescriptor;.org/apache/derby/iapi/types/DataTypeDescriptor getTypeId&()Lorg/apache/derby/iapi/types/TypeId;"org/apache/derby/iapi/types/TypeId isLOBTypeIdacceptZ(Lorg/apache/derby/iapi/sql/compile/Visitor;)Lorg/apache/derby/iapi/sql/compile/Visitable;hasCorrelatedCRs(IID)IgetReferencedFormatableBitSet9(ZZZ)Lorg/apache/derby/iapi/services/io/FormatableBitSet;2org/apache/derby/iapi/services/io/FormatableBitSetisSet getExpression/()Lorg/apache/derby/impl/sql/compile/ValueNode;getTypeServicesestimatedMemoryUsageisIndexfeasible(Lorg/apache/derby/iapi/sql/compile/Optimizable;Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/compile/Optimizer;)ZisOneRowResultSet getPropertynewCostEstimatescratchCostEstimate+org/apache/derby/impl/sql/compile/TableName getSchemaName makeTableNameS(Ljava/lang/String;Ljava/lang/String;)Lorg/apache/derby/impl/sql/compile/TableName;0(Lorg/apache/derby/impl/sql/compile/TableName;)ZgetNodeFactory1()Lorg/apache/derby/iapi/sql/compile/NodeFactory;getContextManager9()Lorg/apache/derby/iapi/services/context/ContextManager;-org/apache/derby/iapi/sql/compile/NodeFactorygetNodek(ILorg/apache/derby/iapi/services/context/ContextManager;)Lorg/apache/derby/impl/sql/compile/QueryTreeNode;(ILjava/lang/Object;Ljava/lang/Object;Lorg/apache/derby/iapi/services/context/ContextManager;)Lorg/apache/derby/impl/sql/compile/QueryTreeNode;addResultColumnK(Ljava/lang/String;)Lorg/apache/derby/iapi/sql/dictionary/SchemaDescriptor;"org/apache/derby/iapi/util/JBitSetset:org/apache/derby/iapi/sql/compile/OptimizablePredicateListgetOptPredicate;(I)Lorg/apache/derby/iapi/sql/compile/OptimizablePredicate;&equalsComparisonWithConstantExpression2(Lorg/apache/derby/iapi/sql/compile/Optimizable;)ZgetRelop8()Lorg/apache/derby/impl/sql/compile/RelationalOperator;4org/apache/derby/impl/sql/compile/RelationalOperatorgetColumnOperandd(Lorg/apache/derby/iapi/sql/compile/Optimizable;)Lorg/apache/derby/impl/sql/compile/ColumnReference;1org/apache/derby/impl/sql/compile/ColumnReferencegetColumnNumbercolumnAlwaysOrdered3(Lorg/apache/derby/iapi/sql/compile/Optimizable;I)V VR(*****'*+ *, * ** j^***,-+:*+W******,-+*+*,*-*+66*:*M 6n+*! "**#$6?*%6+*%& *Y%`%6+* '*-,(*)***+*,*-*-}q+.M+* ,1* *'+**,2* +',+*+,3* +',4* +' ** *+ * =* /N-0-1 :* 2 :34*564#**7*8*9:;47*<:>$* *??:@4#**7*A*9:B3$,~=*CD#**,EW*F**GN:e-**HYI*,JK:',LKY,LM:KYLM:-N*,OW**,JK: P-QN)!*RN *SN*G-Q*T *,*T:UV *,-W:*X*:*Y:*GZ*-[-.* -'_S*+\*-*R[N--]]]_*S[N--]]]_*` ,*a*%* <0*b*b*G**b**G[b*bI=<*cd1*cefM,g,hN--ij'kYlL*+mW+n *   *      +**op**c*qrL*=+s9+t+*cefN-uv:*Ywc*WM,,x*,y*Yzc**|*+|**+,}?3*'~'6**  *cd*YM*)*KY+M)***KY+M**+*KY+M+*,*KY+M, !")***c*qr*#* * 3$%&"* *+*'&"* *+*()***+*)*++D,- :* -: #+*+* : ** : ++ * -:** :* *:,d6 6   J, ef:*>*:*P*f: ./ 012* 34."* **** *52*6 *72* *Yd89 **8: *+M,;<!,*C+4*=>?@A*BC*  +* DE *c+FGHI JKVJ,H>,<,:*!*:+*LMN*+O4*