0                         !"#$%&' ()*+ ,-./012 3456789:;<=>?@ABCD EFGHIJKLMN OPQR STUVWXYZ Y[ Y\ Y] ^_`abc Yde Yfg Yhijklcc:Lorg/apache/derby/iapi/sql/conn/LanguageConnectionContext;O(Lorg/apache/derby/iapi/sql/compile/OptimizableList;Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;ZZZI[Lorg/apache/derby/iapi/sql/compile/JoinStrategy;ILorg/apache/derby/iapi/sql/compile/RequiredRowOrdering;ILorg/apache/derby/iapi/sql/conn/LanguageConnectionContext;)VCode ExceptionslgetLevel()InewCostEstimate2()Lorg/apache/derby/iapi/sql/compile/CostEstimate;getNewCostEstimate9(DDD)Lorg/apache/derby/impl/sql/compile/CostEstimateImpl;trace(IIIDLjava/lang/Object;)V costForTable'(Ljava/lang/Object;I)Ljava/lang/String;bestCost()Ljava/lang/String;buildJoinOrder*(Ljava/lang/String;ZI[I)Ljava/lang/String;lockModeThreshold:(Ljava/lang/String;Ljava/lang/String;DI)Ljava/lang/String; costIncluding9(Ljava/lang/String;Ljava/lang/Object;I)Ljava/lang/String;dumpConglomerateDescriptorQ(Lorg/apache/derby/iapi/sql/dictionary/ConglomerateDescriptor;)Ljava/lang/String; mn op qr sp tr 8org/apache/derby/impl/sql/compile/Level2CostEstimateImpl u vjava/lang/StringBufferOptimization started at time wx yz w{ using optimizer | } w~ #Optimization time exceeded at time z No tables to optimize.We have a complete join order.Cost of sorting is  wNo best plan found.'Modifying access paths using optimizer r time exceededcost      no best plan foundShort circuiting based on  at join position  Skipping join order: 'User specified join order is not legal.1User-specified join order has now been optimized. Considering join order: )Total cost of non-sort-avoidance plan is %Total cost of sort avoidance plan is >Total cost of non-sort-avoidance plan with sort cost added is 7Current plan is a sort avoidance plan. Best cost is :  This cost is : !This is the cheapest plan so far. Plan is a normalsort avoidance plan.Cost of cheapest plan is Sort needed for ordering: w Row ordering: " Remembering join order as best: /V]d-Hc~-Ht{Og,NpCa>`* Y  **: S Y **: ,: %:  Y *: :  Y *: * !": *#*$*%.&:  '(): Y * +*%: *,*$-: t.: m/: f*0*$-: U Y 1*2: : Y 3*4:  Y 5*2:  Y 6*78*4: 9: ֻ Y :;<=:  Y >*2:  Y ?@A*B: f*C*D-: U Y E*F: : Y GHIJ: K: L: MM: Y N : 6   6 Y  O P  .: ȧQ: R: Y S J: n Y TUVW<: 3 Y X: Y:*Z: Y [J: \:  Y ]: ˻ Y ^: _:  Y `HJ: a: Y:*Z: Y b*c: V Y dJ: 4 Y eHJ: *fg: Y hJ:  Y ijk: *lmn: *opn: *qg: *rg: *sg: t*tg: f*ug: X Y vH: ? Y w*c: ! Y xy: z: {: |: Y:*Z: Y }~: : Y H: Y H: f Y H: D Y H: " Y H: * Y  $ Y +J( Y *7h\ Y :+W6*%.WW*W<0 Y +)H,." Y +*,cM+N+t-p+:: Y -.d2M6) Y ,-.d2Mջ Y ,M Y ++++@,