йЧ╨Ў0` Ё12 1 ╡3 ╡4 ╡5 ╡6 ╡7 ╡8ОЪЪЪЪЪЪ ╡9:; ╡<:= ╡> ╡? ╡@ ╡A ╡B ╡C ╡D ╡E ╡F ╡G ╡H ╡I ╡J ╡K ╡L ╡MN O ╡P ╡Q:RST U VW ╡X ╡Y ╡Z ╡[ ╡\ ╡]m=m^_ 0` ╡a ╡b ╡c ╡d ╡e:f ╡g ■h ╡i ╡j ■kSlmnop ╡qSr ╡s:tu Шv:wHxymzS{ ╡|S}S~ ■ ─S│H┌ ■┐ ■xH┐ ■┌ ╡└S┘S├o┤ ┬ ╡┴ 0┼ ▀ = ▄ █ ▌ ▐░ c▒▓ e├ c⌠ e■ ∙ 0■S√m≈≤S≥S Hk ╡⌡ ╡°²·²÷ ╡═²║ ■╒Sё²є²╔SіSї ╡╗ ╡╘m╙m╚S╛mґmў ╡╞m╟m╠m╡mЁSЄ ╣ІmЇS╦Hh²╧S╨╩:╪SҐ:Ў© ■1 ╡юSаH бцде фг©ПSхийSк ■л:м ╔н ╔=о ╔1 ╔пб ╔яр ╙1 ╙= ╙^ 0с 0тmу ╙≈жвьdDictionary5Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;numTablesInQueryInumOptimizablesassignedTableMap$Lorg/apache/derby/iapi/util/JBitSet;optimizableList3Lorg/apache/derby/iapi/sql/compile/OptimizableList; predicateList(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;I)VCode ExceptionsыprepForNextRound()VgetMaxMemoryPerTable()IgetNextPermutation()ZrewindJoinOrderendOfRoundCleanup recoverCostFromProposedJoinOrder(Z)DjoinOrderMeetsDependencies(I)ZpullOptimizableFromJoinOrderpushPredicatesV(Lorg/apache/derby/iapi/sql/compile/Optimizable;Lorg/apache/derby/iapi/util/JBitSet;)VgetNextDecoratedPermutationrememberBestCost4(Lorg/apache/derby/iapi/sql/compile/CostEstimate;I)VcostPermutationcostOptimizable(Lorg/apache/derby/iapi/sql/compile/Optimizable;Lorg/apache/derby/iapi/sql/dictionary/TableDescriptor;Lorg/apache/derby/iapi/sql/dictionary/ConglomerateDescriptor;Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/compile/CostEstimate;)VruleBasedCostOptimizablecostBasedCostOptimizableconsiderCostн(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;)VgetDataDictionary7()Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;modifyAccessPathsnewCostEstimate2()Lorg/apache/derby/iapi/sql/compile/CostEstimate;getOptimizedCostgetFinalCostsetOuterRows(D)VgetNumberOfJoinStrategiesgetJoinStrategy3(I)Lorg/apache/derby/iapi/sql/compile/JoinStrategy;D(Ljava/lang/String;)Lorg/apache/derby/iapi/sql/compile/JoinStrategy;uniqueJoinWithOuterTable?(Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;)D isPushable;(Lorg/apache/derby/iapi/sql/compile/OptimizablePredicate;)ZestimateTotalCost (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/Optimizable;)Lorg/apache/derby/iapi/sql/compile/CostEstimate;getLevelgetNewCostEstimate9(DDD)Lorg/apache/derby/impl/sql/compile/CostEstimateImpl;trace(IIIDLjava/lang/Object;)VupdateBestPlanMaps(SLjava/lang/Object;)VaddScopedPredicatesToList4(Lorg/apache/derby/impl/sql/compile/PredicateList;)VВЩ1org/apache/derby/impl/sql/compile/RowOrderingImplХИЙИ)*ужвжьжыжзшэЇ╦щЪ╧╦абр╦сбцбд╦╪ҐЎ©╣ІтфчфН╦АБЮ╦ЦДъф"org/apache/derby/iapi/util/JBitSetВч╨╩ю╩ъЮАБЦДЕФГХзшОфПЯРСУфЖфИЙ+org/apache/derby/impl/sql/compile/PredicateКщфефЛф+,ЩЛМэшНЕфЩОПЯРСТУЖВЩЬЫЗ42Y70ШЭЬЩЧ.org/apache/derby/iapi/sql/compile/CostEstimateЪ .Щ Р ЧЧ ЪчЕ$%ЦЕчЕЪ9org/apache/derby/impl/sql/compile/BaseTableNumbersVisitorВЕ+org/apache/derby/impl/sql/compile/FromTableЕч%ч:org/apache/derby/iapi/sql/compile/OptimizablePredicateListРФГ !" #$%&'Щ(Щ)*+,-Ъ./0123&'4567879ч:;<=>?@A#BCЩ42Y69DEFGHI2org/apache/derby/impl/sql/compile/CostEstimateImplТГJРKLMNOPQRST#UV!WВъXYjava/util/HashMapYZ[/org/apache/derby/impl/sql/compile/PredicateList\]Щ^_/org/apache/derby/impl/sql/compile/OptimizerImpljava/lang/Object+org/apache/derby/iapi/sql/compile/Optimizer-org/apache/derby/iapi/error/StandardException1org/apache/derby/iapi/sql/compile/OptimizableListverifyProperties8(Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;)Vsize(I)VgetOptimizable2(I)Lorg/apache/derby/iapi/sql/compile/Optimizable;-org/apache/derby/iapi/sql/compile/OptimizablegetReferencedTableMap&()Lorg/apache/derby/iapi/util/JBitSet;or'(Lorg/apache/derby/iapi/util/JBitSet;)Vjava/lang/SystemcurrentTimeMillis()JgetOptPredicate;(I)Lorg/apache/derby/iapi/sql/compile/OptimizablePredicate;isScopedForPushinitAccessPaths0(Lorg/apache/derby/iapi/sql/compile/Optimizer;)VisUninitializedcompare3(Lorg/apache/derby/iapi/sql/compile/CostEstimate;)DgetBestAccessPath0()Lorg/apache/derby/iapi/sql/compile/AccessPath;,org/apache/derby/iapi/sql/compile/AccessPathgetCostEstimate-org/apache/derby/iapi/sql/compile/RowOrderingcopy2(Lorg/apache/derby/iapi/sql/compile/RowOrdering;)VlegalJoinOrder'(Lorg/apache/derby/iapi/util/JBitSet;)ZoptimizeJoinOrdernewExceptionC(Ljava/lang/String;)Lorg/apache/derby/iapi/error/StandardException;singleScanRowCount()DsetCostEstimate3(Lorg/apache/derby/iapi/sql/compile/CostEstimate;)VstartOptimizing_(Lorg/apache/derby/iapi/sql/compile/Optimizer;Lorg/apache/derby/iapi/sql/compile/RowOrdering;)VpullOptPredicates?(Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;)VupdateBestPlanMapsetCost(DDD)VclearAllgetBestSortAvoidancePathgetEstimatedCostrowCountconsiderSortAvoidancePathgetTableNumberremoveOptimizablexorgetReferencedMapsetTogetclearandgetFirstSetBitsetTableMapacceptZ(Lorg/apache/derby/iapi/sql/compile/Visitor;)Lorg/apache/derby/iapi/sql/compile/Visitable;setpushOptPredicateremoveOptPredicatenextAccessPath⌡(Lorg/apache/derby/iapi/sql/compile/Optimizer;Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/compile/RowOrdering;)ZgetCurrentAccessPath5org/apache/derby/iapi/sql/compile/RequiredRowOrdering getSortNeededestimateCostc(DLorg/apache/derby/iapi/sql/compile/RowOrdering;Lorg/apache/derby/iapi/sql/compile/CostEstimate;)VsortRequirede(Lorg/apache/derby/iapi/sql/compile/RowOrdering;Lorg/apache/derby/iapi/sql/compile/OptimizableList;)IrememberAsBest1(ILorg/apache/derby/iapi/sql/compile/Optimizer;)V sortNotNeeded sortNeededfeasibleJoinStrategyl(Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/compile/Optimizer;)Z 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;getLockModeusefulo(Lorg/apache/derby/iapi/sql/compile/Optimizable;Lorg/apache/derby/iapi/sql/dictionary/ConglomerateDescriptor;)ZisCoveringIndex@(Lorg/apache/derby/iapi/sql/dictionary/ConglomerateDescriptor;)ZgetCoveringIndexScangetNonMatchingIndexScansetConglomerateDescriptor@(Lorg/apache/derby/iapi/sql/dictionary/ConglomerateDescriptor;)VsetNonMatchingIndexScan(Z)VsetCoveringIndexScansetLockModerememberJoinStrategyAsBest1(Lorg/apache/derby/iapi/sql/compile/AccessPath;)V;org/apache/derby/iapi/sql/dictionary/ConglomerateDescriptorisIndexgetConglomerateDescriptor?()Lorg/apache/derby/iapi/sql/dictionary/ConglomerateDescriptor; memoryUsageOK(DI)Z┴(Lorg/apache/derby/iapi/sql/compile/RowOrdering;Lorg/apache/derby/iapi/util/JBitSet;Lorg/apache/derby/iapi/sql/compile/OptimizableList;)IrememberSortAvoidancePathreOrder([I)VmodifyAccessPathU(Lorg/apache/derby/iapi/util/JBitSet;)Lorg/apache/derby/iapi/sql/compile/Optimizable;setOptimizable3(ILorg/apache/derby/iapi/sql/compile/Optimizable;)VgetTrulyTheBestAccessPath%org/apache/derby/iapi/util/StringUtilSQLToUpperCase&(Ljava/lang/String;)Ljava/lang/String;.org/apache/derby/iapi/sql/compile/JoinStrategygetName()Ljava/lang/String;java/lang/Stringequals(Ljava/lang/Object;)Z uniqueJoin6org/apache/derby/iapi/sql/compile/OptimizablePredicatehasSubquery7(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;remove&(Ljava/lang/Object;)Ljava/lang/Object;put8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;isScopedToSourceResultSetclearScanFlagsaddOptPredicate;(Lorg/apache/derby/iapi/sql/compile/OptimizablePredicate;)V!╡ЁЄ-╣ІЇ╦╧╦╨╩╪ҐЎ©ю╩абцбд╦ефг╦хий╦хкл╦хмн╦хоп╦хяр╦сбтфужвжьжыжзшэшщфчфъфЮ╦АБЦДЕфФГХИЙИКфЛфМфН╦ОфПЯРСТГУфЖф$ВЬЫ`T*Ї*╩YЇ╣*╩YЇ╣**І╣**І╣**І╣ ** І╣+-╧ *╣*+╧╣**Є╪ ╣є*╣**Є╪ ╣ї*╣6*Є╒*ЄO└їЪЛ**Є╪ ╣*╣*+╣*,╣*-╣*╣*╣*╣*╣* ╣* ╣*╣*╩ YЇ!╣"*╩ YЇ!╣#6*Є╒!+╧$: *Є# ╧%І&└їЪэ*╦'╣(*╣)*╣** ╣+*╣,*╣-╠ЗШЭЩЫ└x*╣)** І╣*╣,*Єф@*Є╧.·4*Є╧.d<⌡$*Є╧/ю0І1≥*╣,ї └ЪїЪч*Є,≥*╦'╣(*╣2*╣3╠ЧЪЫ*Є╛Ыъ с*Є╒*Є4≥*І5*Ї6╛*Є*╧7*Є2 L*ЄєC*Є <*╦'╣8**Є8*Є(e┼*Є+≈·ї╣2*Є4≥*Є2≥*І5*ЄІ9≥n*Є:≥g*Є, *Є-≥ *Є2≥R*Є÷E*Єг **Є╪ ╣<*Є╒*Є*Є.O└їЪИ*╣*Є⌡*Ї;*╣*╣2<*ЄІ9 .*Є*ЄІ<≈·*Єф*Є *ЄІ<≈·ї=*Є*Єd╒P L*Є2 E*Є⌡"*Є*Є*Є.╧$╧=╧>фO*YЄ`╣<*Є*Є╧?ї3*Є4≥*Є*Єd╒ *І5*Є*Єd╒*╣)*Є═ *Є⌡*╣)*Ї;*╣*Є⌡Ь*Є*Є.`>*Є*Є.⌡*Ї@*Є3 *Є2≥*Є>їV*Є═н*Є*Є.6>*Є66*Є╧$:*Є"╧A ~⌡*Є*ЄO*ЄO*Є`є)*Є└Ъ.6*Є*ЄO*ЄO>ї%*Є·*YЄd╣*╣)*Ї;*╣ї*Є╧$:їЪz*Є їЪ*Є*Єd═*╣ї┐*Є╒{66*Є╒*Є.═ 6ї └їЪЦ≥їG*Є╒E*ЇB =*Є4≥ * І5*Є╧C *Є4≥ * І5D╦E©└їЪ┐*Є║}*Є╧C @*Є*Є╧F *Є4≥ * І5D╦E©*Є4≥ *І5*╣3*Є═*Є·Ъ*Є*Єd═Р*╣*Є╪:6*Є╒B*ЄO*Є╧$╧=╧>:г*╣ї╧GR└їЪ╩*Є═▓66*Є╒h6`6 *Є╒ 11≤° 6└ їЪБ÷01R*Є.6*Є*Є.O*ЄO6└їЪ∙≥*YЄd╣*Ї;їЩ *╣*YЄd╣*Є°Щ *Є═Щ*╣*╣їЭУ*Є*ЄO*Є═|66*Є╒4*Є.*Є.╒ 6ї*Є.*Є.єї └їЪи≥7*Є*ЄO*YЄd╣*Є⌡*╣)*Ї;*╣*╣*Ї6╛*Є╧$╧=юH╧I*Є4≥ *І5*Є╧$:*Є"╧%І&**Є╧J**Є╧$*Є"ІK╛*Ї6╛ЗШЩЫui*Є*Є*Є.╧$L+*Є╧L*Є)≥+*╧M*Є*ЄO*Є ї*YЄd╣їЪІ*ЄІN*Є ІN*Є"ІO╠ЗШЩЫ."<*Є╒*Є╧$*╧M└їЪД╠ЗШЫmaI6*Є╒T≥((*Є*Є.╧$╧P╧>╧QcIї%(*Є*Є.╧$╧=╧>╧QcI└їЪ╘(╞ЗШЫ"*Є╧$M,*Є"╧A╛ЗШЩЫуи*Є*Є*Є.╧$L6*Є *ЄІRI*ЄІS9ї8*Є*Єd.6*Є╧$╧=╧>:╧TI╧G9*ЄІU99 +╧=╧>:ф.╧Q9 g9≤²*Є 9ї *ЇV9*Є *Єф*ЄІU9ї9*Є(ІN*Єф╪+╧W≥Ё+╧P:9 *Є *ЄІRI*ЄІS9*ЄІU9 їA*Є╧$╧P╧>:╧TI╧G9*Є ІU╧>╧Qg9 ≤²*Є 9 ї *ЇV9 *Є (ІN*Є+╧X╧Y*Є*Є╧?+*Є╧L*Є)≥+*╧M*Є*ЄO*Є"+╧%ІZ╠ЗШ Ы9-*Є╧.>╩ Y*ЄЇ!:::6d6 ⌡*Є ╧/ю0: * Ї[ їЦ І\І]6І^╒,І_≥ І`└їЪЦ*Є#ІaІb═ї6≥} І1≥u*Єєmг╩ Y*ЄЇ!:╩cYЇd:+юeІf6ІOІg+юeІhW⌡ ІiІg ІjWІaІb═6≥+ ╧k≥*Є ╧l└ ЪїЧЭ╠ЗШЫj ^*Є*Є*Є.╧$MJ,*юm*Є╧n<,╧=╧>фh,╧o╧>фZ,╧=╧>,╧o╧>╧p≈≥,,╧Mї/,╧=╧>╧T,╧o╧>╧T≤°,,╧M,,╧M,╧=╧>: ўф╘*Є*ЄІU╧Qc╧T╧GІN,╧W≥;*Єф4,╧P╧>:*Є *Є ІU╧Qc╧T╧GІN*Є4≥ * І5,╧W≥ *І5*Є*Єd═*Є4≥*І5*Єф76*Єqг**Іr╣qї╩*Є╧s≥╞*ЄІR*ЄІR≈·o*Є*ЄІR*Є*Єq╧t*Єq╧Q9*Є*ЄІR*Є*Єq╧t6*Є*ЄІUg*Єq╧Qc*Єq╧T*ЄІSІNї1*ЄІR*ЄІR≤°*Є*ЄІU*ЄІR*ЄІSІN *Є*ЄІR*Є*Єq╧t*ЄІRJ*Є*ЄІU*Єq╧Qc*Єq╧T*ЄІSІN*Є4≥*І5*І5*Є:≥*Є*ЄІ<≤⌡ *ЄІ9≥**ЄЇu*╣)ї*╣)*Єф1*ЄІU*Єq╧Qg9≤°9*Є)*ЄІSІN*ЄфU,╧W≥L*Є*Є*Є╧v═7*Є4≥ *І5*Є *ЄІ<≤· *ЄІ9≥**Є Їu╛ЗШ ЫФз*╣:*Є4≥!*І5*І5*І5*Є+Іw*ЄІU*Є+≤°**ЄІU╣+**Є,╣->*Є╒*Є*Є.O└їЪИ>*Є╒*Є*Є.╧$*╧x└їЪъ*Єф═*Є╧yї*Є╧z*Є4≥*Єф *І5*І5╠ЗШЩЫnb*Є *ЄLї"*Є*Є*Єd.╧$╧=╧>L*Є*Є*Є.╧$M,*Є*╧{ ╠,**Є+*Є╧|W╠ЗШЫ:.+*╧{ ╠*Є≥*+,-Ї}ї*+,-Ї~╠ЗШЫ▒┘::+╧=:+╧o╧6 фv+-╧─≥j+-╧│6 ╧┌≥╧┐ ≥G*-+Ї└╧I-╧┘╧├ ╧┤+╧o╧╧┬+╧┴╠+-╧│≥G*-+Ї└╧I-╧┘╧├╧┤+╧o╧╧┬+╧┴╠╧┌ H╧┐≥>-І┼ 7*-+Ї└╧I-╧┘+╧o╧╧┬+╧┴╠╧▀:гI*-+Ї└╧I-╧┘╧┤-І┼╧├+╧o╧╧┬+╧┴╠ЗШЫ╡ і*-+Ї└:+╧o╧I+╧T╧To*Є╧▄ *Є4≥ *І5╠+╧=:╧>:ф╧█ ╧p≤°Y-╧┘╧I+-╧│╧┤ф+-╧─ ї╧├+╧o╧╧┬+╧┴*Єфж*Є≥*Є*Є*Єd.╧$╧W≥Ё*Є*Є*Є"*Є╧▌═ +╧P:╧>:ф╧█ ╧p≤°l-╧┘╧I+-╧│╧┤ф+-╧─ ї╧├+╧o╧╧┬+╧┴+╧▐*Є*Є╧?╠ЗШЫ"+,*╧{ ╠+╧o-╧I+-╧T╧To*Є╧▄ *Є4≥ *І5╠+╧=:╧>:ф╧█ -╧p≤²-╧I+╧┴*Єф▐*Є≥*Є*Є*Єd.╧$╧W≥l*Є*Є*Є"*Є╧▌═S+╧P:╧>:ф╧█ -╧p≤°&-╧I+╧┴+╧▐*Є*Є╧?╠ЗШЫ*Є╟ЩЫ▒┘*Є4≥ *І5*Є: *Є4≥ *І5░╦E©*Є*Є╧▒╩ Y*ЄЇ!L=*Є╒5*Є╧$N+-╧%І&*-+ІK*Є-+╧▓╧⌠└їЪи╠ЗШЫ╩■YЇ∙╟Ы*Є╟Ыzn*Є√ф*Є√╟**І╣√L=*ЄЎ╒H*Є*Є.╧$╧≈╧>L*Є√*Є√╧Q+╧Qc+╧T+╧G╧≤└їЪ╣*Є√╟Ы#*Є*ЄІU'*ЄІSІN╠ЮЪЫ*Є╛ЪЫ*ЄЎ╛ Ы*Є2╟!ЫC7M+╦≥N6*ЄЎ╒$-*Є2╧ І⌡≥*Є2M└їЪь,╟"#Ыrf°I9*ЄІR9+фF*Єd6⌡9*Є*Є.╧$: +╧·9 ≈· +╧·k9└ЪїЪх≈≥ oI(╞ЗШ$%Ы +╧÷≥╛╛&'Ы +,-**Є╧═:╟ЗШ(ЪЫ╛)*Ы╩■Y')Ї║╟+,Ы ╠ъЫ%*Є≥*Є╧╒≥ї╛-.ЫЬЛ*Єє©N %*Є*ф╡*Є*,ІёW*Є*Іє ÷*╣*ї≈═]*Є*г*╩╔YЇі╣*ї*Є*,Іїю╗ю╗N-г *Є╪ N6*ЄЎ╒-*Є.O└їЪХ*Є*,-І╘Wї8*Є*ф1*Є*,Іїю╗ю╗N-ф6-Ў╒*Є-.O└їЪК*Є╧d>⌡*Є╧$,╧M└ЪїЪХ╠ЗШ/0Ы≈▀+ф+*Єі╠*Єг*╩╙YЇ╚╣M*Є╧.d>⌡(*Є╧/ю0M,І1≥ *Є╧l└ЪїЪз+І╛d>⌡,+Іґю0M,Іў≥,І╞*Є,╧╟+І╠└ЪїЪж╠ЗШ