Edit C:\Program Files\Java\jdk1.7.0_45\db\lib\org\apache\derby\iapi\sql\compile\Optimizer.class
Êþº¾ 0 ½ ´ µ MODULE Ljava/lang/String; ConstantValue ¶ JOIN_ORDER_OPTIMIZATION · RULE_BASED_OPTIMIZATION ¸ NO_TIMEOUT ¹ MAX_MEMORY_PER_TABLE º MAX_DYNAMIC_MATERIALIZED_ROWS I USE_STATISTICS » NORMAL_PLAN SORT_AVOIDANCE_PLAN STARTED TIME_EXCEEDED NO_TABLES COMPLETE_JOIN_ORDER COST_OF_SORTING NO_BEST_PLAN MODIFYING_ACCESS_PATHS SHORT_CIRCUITING SKIPPING_JOIN_ORDER ILLEGAL_USER_JOIN_ORDER USER_JOIN_ORDER_OPTIMIZED CONSIDERING_JOIN_ORDER TOTAL_COST_NON_SA_PLAN TOTAL_COST_SA_PLAN TOTAL_COST_WITH_SORTING CURRENT_PLAN_IS_SA_PLAN CHEAPEST_PLAN_SO_FAR PLAN_TYPE COST_OF_CHEAPEST_PLAN_SO_FAR SORT_NEEDED_FOR_ORDERING REMEMBERING_BEST_JOIN_ORDER SKIPPING_DUE_TO_EXCESS_MEMORY COST_OF_N_SCANS HJ_SKIP_NOT_MATERIALIZABLE HJ_SKIP_NO_JOIN_COLUMNS HJ_HASH_KEY_COLUMNS CALLING_ON_JOIN_NODE CONSIDERING_JOIN_STRATEGY REMEMBERING_BEST_ACCESS_PATH NO_MORE_CONGLOMERATES CONSIDERING_CONGLOMERATE &SCANNING_HEAP_FULL_MATCH_ON_UNIQUE_KEY ADDING_UNORDERED_OPTIMIZABLE ! CHANGING_ACCESS_PATH_FOR_TABLE " TABLE_LOCK_NO_START_STOP # NON_COVERING_INDEX_COST $ ROW_LOCK_ALL_CONSTANT_START_STOP % ESTIMATING_COST_OF_CONGLOMERATE & LOOKING_FOR_SPECIFIED_INDEX ' MATCH_SINGLE_ROW_COST ( (COST_INCLUDING_EXTRA_1ST_COL_SELECTIVITY ) CALLING_NEXT_ACCESS_PATH * TABLE_LOCK_OVER_THRESHOLD + ROW_LOCK_UNDER_THRESHOLD , COST_INCLUDING_EXTRA_START_STOP - *COST_INCLUDING_EXTRA_QUALIFIER_SELECTIVITY . -COST_INCLUDING_EXTRA_NONQUALIFIER_SELECTIVITY / COST_OF_NONCOVERING_INDEX 0 REMEMBERING_JOIN_STRATEGY 1 &REMEMBERING_BEST_ACCESS_PATH_SUBSTRING 2 5REMEMBERING_BEST_SORT_AVOIDANCE_ACCESS_PATH_SUBSTRING 3 .REMEMBERING_BEST_UNKNOWN_ACCESS_PATH_SUBSTRING 4 COST_OF_CONGLOMERATE_SCAN1 5 COST_OF_CONGLOMERATE_SCAN2 6 COST_OF_CONGLOMERATE_SCAN3 7 COST_OF_CONGLOMERATE_SCAN4 8 COST_OF_CONGLOMERATE_SCAN5 9 COST_OF_CONGLOMERATE_SCAN6 : COST_OF_CONGLOMERATE_SCAN7 ; 'COST_INCLUDING_COMPOSITE_SEL_FROM_STATS < COMPOSITE_SEL_FROM_STATS = COST_INCLUDING_STATS_FOR_INDEX > getNextPermutation ()Z Exceptions ¼ getNextDecoratedPermutation costPermutation ()V costOptimizable(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;)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;)V getDataDictionary 7()Lorg/apache/derby/iapi/sql/dictionary/DataDictionary; modifyAccessPaths newCostEstimate 2()Lorg/apache/derby/iapi/sql/compile/CostEstimate; getOptimizedCost getFinalCost prepForNextRound setOuterRows (D)V getNumberOfJoinStrategies ()I tableLockThreshold getJoinStrategy 3(I)Lorg/apache/derby/iapi/sql/compile/JoinStrategy; D(Ljava/lang/String;)Lorg/apache/derby/iapi/sql/compile/JoinStrategy; trace (IIIDLjava/lang/Object;)V getLevel uniqueJoinWithOuterTable ?(Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;)D useStatistics getMaxMemoryPerTable +org/apache/derby/iapi/sql/compile/Optimizer java/lang/Object +org.apache.derby.iapi.sql.compile.Optimizer !derby.optimizer.optimizeJoinOrder %derby.optimizer.ruleBasedOptimization derby.optimizer.noTimeout derby.language.maxMemoryPerTable derby.language.useStatistics -org/apache/derby/iapi/error/StandardException G ! "