class org.h2.command.dml.Optimizer
  minor version: 0
  major version: 59
  flags: flags: (0x0020) ACC_SUPER
  this_class: org.h2.command.dml.Optimizer
  super_class: java.lang.Object
{
  private static final int MAX_BRUTE_FORCE_FILTERS;
    descriptor: I
    flags: (0x001a) ACC_PRIVATE, ACC_STATIC, ACC_FINAL
    ConstantValue: 7

  private static final int MAX_BRUTE_FORCE;
    descriptor: I
    flags: (0x001a) ACC_PRIVATE, ACC_STATIC, ACC_FINAL
    ConstantValue: 2000

  private static final int MAX_GENETIC;
    descriptor: I
    flags: (0x001a) ACC_PRIVATE, ACC_STATIC, ACC_FINAL
    ConstantValue: 500

  private long startNs;
    descriptor: J
    flags: (0x0002) ACC_PRIVATE

  private java.util.BitSet switched;
    descriptor: Ljava/util/BitSet;
    flags: (0x0002) ACC_PRIVATE

  private final org.h2.table.TableFilter[] filters;
    descriptor: [Lorg/h2/table/TableFilter;
    flags: (0x0012) ACC_PRIVATE, ACC_FINAL

  private final org.h2.expression.Expression condition;
    descriptor: Lorg/h2/expression/Expression;
    flags: (0x0012) ACC_PRIVATE, ACC_FINAL

  private final org.h2.engine.Session session;
    descriptor: Lorg/h2/engine/Session;
    flags: (0x0012) ACC_PRIVATE, ACC_FINAL

  private org.h2.table.Plan bestPlan;
    descriptor: Lorg/h2/table/Plan;
    flags: (0x0002) ACC_PRIVATE

  private org.h2.table.TableFilter topFilter;
    descriptor: Lorg/h2/table/TableFilter;
    flags: (0x0002) ACC_PRIVATE

  private double cost;
    descriptor: D
    flags: (0x0002) ACC_PRIVATE

  private java.util.Random random;
    descriptor: Ljava/util/Random;
    flags: (0x0002) ACC_PRIVATE

  private final org.h2.command.dml.AllColumnsForPlan allColumnsSet;
    descriptor: Lorg/h2/command/dml/AllColumnsForPlan;
    flags: (0x0012) ACC_PRIVATE, ACC_FINAL

  void <init>(org.h2.table.TableFilter[], org.h2.expression.Expression, org.h2.engine.Session);
    descriptor: ([Lorg/h2/table/TableFilter;Lorg/h2/expression/Expression;Lorg/h2/engine/Session;)V
    flags: (0x0000) 
    Code:
      stack=4, locals=4, args_size=4
        start local 0 // org.h2.command.dml.Optimizer this
        start local 1 // org.h2.table.TableFilter[] filters
        start local 2 // org.h2.expression.Expression condition
        start local 3 // org.h2.engine.Session session
         0: .line 52
            aload 0 /* this */
            invokespecial java.lang.Object.<init>:()V
         1: .line 53
            aload 0 /* this */
            aload 1 /* filters */
            putfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
         2: .line 54
            aload 0 /* this */
            aload 2 /* condition */
            putfield org.h2.command.dml.Optimizer.condition:Lorg/h2/expression/Expression;
         3: .line 55
            aload 0 /* this */
            aload 3 /* session */
            putfield org.h2.command.dml.Optimizer.session:Lorg/h2/engine/Session;
         4: .line 56
            aload 0 /* this */
            new org.h2.command.dml.AllColumnsForPlan
            dup
            aload 1 /* filters */
            invokespecial org.h2.command.dml.AllColumnsForPlan.<init>:([Lorg/h2/table/TableFilter;)V
            putfield org.h2.command.dml.Optimizer.allColumnsSet:Lorg/h2/command/dml/AllColumnsForPlan;
         5: .line 57
            return
        end local 3 // org.h2.engine.Session session
        end local 2 // org.h2.expression.Expression condition
        end local 1 // org.h2.table.TableFilter[] filters
        end local 0 // org.h2.command.dml.Optimizer this
      LocalVariableTable:
        Start  End  Slot       Name  Signature
            0    6     0       this  Lorg/h2/command/dml/Optimizer;
            0    6     1    filters  [Lorg/h2/table/TableFilter;
            0    6     2  condition  Lorg/h2/expression/Expression;
            0    6     3    session  Lorg/h2/engine/Session;
    MethodParameters:
           Name  Flags
      filters    
      condition  
      session    

  private static int getMaxBruteForceFilters(int);
    descriptor: (I)I
    flags: (0x000a) ACC_PRIVATE, ACC_STATIC
    Code:
      stack=4, locals=4, args_size=1
        start local 0 // int filterCount
         0: .line 70
            iconst_0
            istore 1 /* i */
        start local 1 // int i
         1: iload 0 /* filterCount */
            istore 2 /* j */
        start local 2 // int j
         2: iload 0 /* filterCount */
            istore 3 /* total */
        start local 3 // int total
         3: .line 71
            goto 7
         4: .line 72
      StackMap locals: int int int
      StackMap stack:
            iinc 2 /* j */ -1
         5: .line 73
            iload 3 /* total */
            iload 2 /* j */
            imul
            istore 3 /* total */
         6: .line 74
            iinc 1 /* i */ 1
         7: .line 71
      StackMap locals:
      StackMap stack:
            iload 2 /* j */
            ifle 8
            iload 3 /* total */
            iload 2 /* j */
            iload 2 /* j */
            iconst_1
            isub
            imul
            iconst_2
            idiv
            imul
            sipush 2000
            if_icmplt 4
         8: .line 76
      StackMap locals:
      StackMap stack:
            iload 1 /* i */
            ireturn
        end local 3 // int total
        end local 2 // int j
        end local 1 // int i
        end local 0 // int filterCount
      LocalVariableTable:
        Start  End  Slot         Name  Signature
            0    9     0  filterCount  I
            1    9     1            i  I
            2    9     2            j  I
            3    9     3        total  I
    MethodParameters:
             Name  Flags
      filterCount  

  private void calculateBestPlan();
    descriptor: ()V
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=5, locals=1, args_size=1
        start local 0 // org.h2.command.dml.Optimizer this
         0: .line 80
            aload 0 /* this */
            ldc -1.0
            putfield org.h2.command.dml.Optimizer.cost:D
         1: .line 81
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            arraylength
            iconst_1
            if_icmpeq 2
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.session:Lorg/h2/engine/Session;
            invokevirtual org.h2.engine.Session.isForceJoinOrder:()Z
            ifeq 4
         2: .line 82
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            invokevirtual org.h2.command.dml.Optimizer.testPlan:([Lorg/h2/table/TableFilter;)Z
            pop
         3: .line 83
            goto 11
         4: .line 84
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            invokestatic java.lang.System.nanoTime:()J
            putfield org.h2.command.dml.Optimizer.startNs:J
         5: .line 85
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            arraylength
            bipush 7
            if_icmpgt 8
         6: .line 86
            aload 0 /* this */
            invokevirtual org.h2.command.dml.Optimizer.calculateBruteForceAll:()V
         7: .line 87
            goto 11
         8: .line 88
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            invokevirtual org.h2.command.dml.Optimizer.calculateBruteForceSome:()V
         9: .line 89
            aload 0 /* this */
            new java.util.Random
            dup
            lconst_0
            invokespecial java.util.Random.<init>:(J)V
            putfield org.h2.command.dml.Optimizer.random:Ljava/util/Random;
        10: .line 90
            aload 0 /* this */
            invokevirtual org.h2.command.dml.Optimizer.calculateGenetic:()V
        11: .line 93
      StackMap locals:
      StackMap stack:
            return
        end local 0 // org.h2.command.dml.Optimizer this
      LocalVariableTable:
        Start  End  Slot  Name  Signature
            0   12     0  this  Lorg/h2/command/dml/Optimizer;

  private void calculateFakePlan();
    descriptor: ()V
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=6, locals=1, args_size=1
        start local 0 // org.h2.command.dml.Optimizer this
         0: .line 96
            aload 0 /* this */
            ldc -1.0
            putfield org.h2.command.dml.Optimizer.cost:D
         1: .line 97
            aload 0 /* this */
            new org.h2.table.Plan
            dup
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            arraylength
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.condition:Lorg/h2/expression/Expression;
            invokespecial org.h2.table.Plan.<init>:([Lorg/h2/table/TableFilter;ILorg/h2/expression/Expression;)V
            putfield org.h2.command.dml.Optimizer.bestPlan:Lorg/h2/table/Plan;
         2: .line 98
            return
        end local 0 // org.h2.command.dml.Optimizer this
      LocalVariableTable:
        Start  End  Slot  Name  Signature
            0    3     0  this  Lorg/h2/command/dml/Optimizer;

  private boolean canStop(int);
    descriptor: (I)Z
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=7, locals=2, args_size=2
        start local 0 // org.h2.command.dml.Optimizer this
        start local 1 // int x
         0: .line 101
            iload 1 /* x */
            bipush 127
            iand
            ifne 4
         1: .line 102
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.cost:D
            dconst_0
            dcmpl
            iflt 4
         2: .line 103
            ldc 10
            invokestatic java.lang.System.nanoTime:()J
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.startNs:J
            lsub
            lmul
            l2d
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.cost:D
            getstatic java.util.concurrent.TimeUnit.MILLISECONDS:Ljava/util/concurrent/TimeUnit;
            lconst_1
            invokevirtual java.util.concurrent.TimeUnit.toNanos:(J)J
            l2d
            dmul
         3: .line 101
            dcmpl
            ifle 4
            iconst_1
            ireturn
      StackMap locals:
      StackMap stack:
         4: iconst_0
            ireturn
        end local 1 // int x
        end local 0 // org.h2.command.dml.Optimizer this
      LocalVariableTable:
        Start  End  Slot  Name  Signature
            0    5     0  this  Lorg/h2/command/dml/Optimizer;
            0    5     1     x  I
    MethodParameters:
      Name  Flags
      x     

  private void calculateBruteForceAll();
    descriptor: ()V
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=2, locals=4, args_size=1
        start local 0 // org.h2.command.dml.Optimizer this
         0: .line 107
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            arraylength
            anewarray org.h2.table.TableFilter
            astore 1 /* list */
        start local 1 // org.h2.table.TableFilter[] list
         1: .line 108
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            aload 1 /* list */
            invokestatic org.h2.util.Permutations.create:([Ljava/lang/Object;[Ljava/lang/Object;)Lorg/h2/util/Permutations;
            astore 2 /* p */
        start local 2 // org.h2.util.Permutations p
         2: .line 109
            iconst_0
            istore 3 /* x */
        start local 3 // int x
         3: goto 6
         4: .line 110
      StackMap locals: org.h2.table.TableFilter[] org.h2.util.Permutations int
      StackMap stack:
            aload 0 /* this */
            aload 1 /* list */
            invokevirtual org.h2.command.dml.Optimizer.testPlan:([Lorg/h2/table/TableFilter;)Z
            pop
         5: .line 109
            iinc 3 /* x */ 1
      StackMap locals:
      StackMap stack:
         6: aload 0 /* this */
            iload 3 /* x */
            invokevirtual org.h2.command.dml.Optimizer.canStop:(I)Z
            ifne 7
            aload 2 /* p */
            invokevirtual org.h2.util.Permutations.next:()Z
            ifne 4
        end local 3 // int x
         7: .line 112
      StackMap locals:
      StackMap stack:
            return
        end local 2 // org.h2.util.Permutations p
        end local 1 // org.h2.table.TableFilter[] list
        end local 0 // org.h2.command.dml.Optimizer this
      LocalVariableTable:
        Start  End  Slot  Name  Signature
            0    8     0  this  Lorg/h2/command/dml/Optimizer;
            1    8     1  list  [Lorg/h2/table/TableFilter;
            2    8     2     p  Lorg/h2/util/Permutations<Lorg/h2/table/TableFilter;>;
            3    7     3     x  I

  private void calculateBruteForceSome();
    descriptor: ()V
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=5, locals=13, args_size=1
        start local 0 // org.h2.command.dml.Optimizer this
         0: .line 115
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            arraylength
            invokestatic org.h2.command.dml.Optimizer.getMaxBruteForceFilters:(I)I
            istore 1 /* bruteForce */
        start local 1 // int bruteForce
         1: .line 116
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            arraylength
            anewarray org.h2.table.TableFilter
            astore 2 /* list */
        start local 2 // org.h2.table.TableFilter[] list
         2: .line 117
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            aload 2 /* list */
            iload 1 /* bruteForce */
            invokestatic org.h2.util.Permutations.create:([Ljava/lang/Object;[Ljava/lang/Object;I)Lorg/h2/util/Permutations;
            astore 3 /* p */
        start local 3 // org.h2.util.Permutations p
         3: .line 118
            iconst_0
            istore 4 /* x */
        start local 4 // int x
         4: goto 39
         5: .line 120
      StackMap locals: org.h2.command.dml.Optimizer int org.h2.table.TableFilter[] org.h2.util.Permutations int
      StackMap stack:
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            dup
            astore 8
            arraylength
            istore 7
            iconst_0
            istore 6
            goto 9
      StackMap locals: org.h2.command.dml.Optimizer int org.h2.table.TableFilter[] org.h2.util.Permutations int top int int org.h2.table.TableFilter[]
      StackMap stack:
         6: aload 8
            iload 6
            aaload
            astore 5 /* f */
        start local 5 // org.h2.table.TableFilter f
         7: .line 121
            aload 5 /* f */
            iconst_0
            invokevirtual org.h2.table.TableFilter.setUsed:(Z)V
        end local 5 // org.h2.table.TableFilter f
         8: .line 120
            iinc 6 1
      StackMap locals:
      StackMap stack:
         9: iload 6
            iload 7
            if_icmplt 6
        10: .line 123
            iconst_0
            istore 5 /* i */
        start local 5 // int i
        11: goto 14
        12: .line 124
      StackMap locals: org.h2.command.dml.Optimizer int org.h2.table.TableFilter[] org.h2.util.Permutations int int
      StackMap stack:
            aload 2 /* list */
            iload 5 /* i */
            aaload
            iconst_1
            invokevirtual org.h2.table.TableFilter.setUsed:(Z)V
        13: .line 123
            iinc 5 /* i */ 1
      StackMap locals:
      StackMap stack:
        14: iload 5 /* i */
            iload 1 /* bruteForce */
            if_icmplt 12
        end local 5 // int i
        15: .line 127
            iload 1 /* bruteForce */
            istore 5 /* i */
        start local 5 // int i
        16: goto 36
        17: .line 128
      StackMap locals:
      StackMap stack:
            ldc -1.0
            dstore 6 /* costPart */
        start local 6 // double costPart
        18: .line 129
            iconst_m1
            istore 8 /* bestPart */
        start local 8 // int bestPart
        19: .line 130
            iconst_0
            istore 9 /* j */
        start local 9 // int j
        20: goto 32
        21: .line 131
      StackMap locals: double int int
      StackMap stack:
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            iload 9 /* j */
            aaload
            invokevirtual org.h2.table.TableFilter.isUsed:()Z
            ifne 31
        22: .line 132
            iload 5 /* i */
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            arraylength
            iconst_1
            isub
            if_icmpne 25
        23: .line 133
            iload 9 /* j */
            istore 8 /* bestPart */
        24: .line 134
            goto 33
        25: .line 136
      StackMap locals:
      StackMap stack:
            aload 2 /* list */
            iload 5 /* i */
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            iload 9 /* j */
            aaload
            aastore
        26: .line 137
            new org.h2.table.Plan
            dup
            aload 2 /* list */
            iload 5 /* i */
            iconst_1
            iadd
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.condition:Lorg/h2/expression/Expression;
            invokespecial org.h2.table.Plan.<init>:([Lorg/h2/table/TableFilter;ILorg/h2/expression/Expression;)V
            astore 10 /* part */
        start local 10 // org.h2.table.Plan part
        27: .line 138
            aload 10 /* part */
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.session:Lorg/h2/engine/Session;
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.allColumnsSet:Lorg/h2/command/dml/AllColumnsForPlan;
            invokevirtual org.h2.table.Plan.calculateCost:(Lorg/h2/engine/Session;Lorg/h2/command/dml/AllColumnsForPlan;)D
            dstore 11 /* costNow */
        start local 11 // double costNow
        28: .line 139
            dload 6 /* costPart */
            dconst_0
            dcmpg
            iflt 29
            dload 11 /* costNow */
            dload 6 /* costPart */
            dcmpg
            ifge 31
        29: .line 140
      StackMap locals: org.h2.table.Plan double
      StackMap stack:
            dload 11 /* costNow */
            dstore 6 /* costPart */
        30: .line 141
            iload 9 /* j */
            istore 8 /* bestPart */
        end local 11 // double costNow
        end local 10 // org.h2.table.Plan part
        31: .line 130
      StackMap locals:
      StackMap stack:
            iinc 9 /* j */ 1
      StackMap locals:
      StackMap stack:
        32: iload 9 /* j */
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            arraylength
            if_icmplt 21
        end local 9 // int j
        33: .line 145
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            iload 8 /* bestPart */
            aaload
            iconst_1
            invokevirtual org.h2.table.TableFilter.setUsed:(Z)V
        34: .line 146
            aload 2 /* list */
            iload 5 /* i */
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            iload 8 /* bestPart */
            aaload
            aastore
        end local 8 // int bestPart
        end local 6 // double costPart
        35: .line 127
            iinc 5 /* i */ 1
      StackMap locals:
      StackMap stack:
        36: iload 5 /* i */
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            arraylength
            if_icmplt 17
        end local 5 // int i
        37: .line 148
            aload 0 /* this */
            aload 2 /* list */
            invokevirtual org.h2.command.dml.Optimizer.testPlan:([Lorg/h2/table/TableFilter;)Z
            pop
        38: .line 118
            iinc 4 /* x */ 1
      StackMap locals:
      StackMap stack:
        39: aload 0 /* this */
            iload 4 /* x */
            invokevirtual org.h2.command.dml.Optimizer.canStop:(I)Z
            ifne 40
            aload 3 /* p */
            invokevirtual org.h2.util.Permutations.next:()Z
            ifne 5
        end local 4 // int x
        40: .line 150
      StackMap locals:
      StackMap stack:
            return
        end local 3 // org.h2.util.Permutations p
        end local 2 // org.h2.table.TableFilter[] list
        end local 1 // int bruteForce
        end local 0 // org.h2.command.dml.Optimizer this
      LocalVariableTable:
        Start  End  Slot        Name  Signature
            0   41     0        this  Lorg/h2/command/dml/Optimizer;
            1   41     1  bruteForce  I
            2   41     2        list  [Lorg/h2/table/TableFilter;
            3   41     3           p  Lorg/h2/util/Permutations<Lorg/h2/table/TableFilter;>;
            4   40     4           x  I
            7    8     5           f  Lorg/h2/table/TableFilter;
           11   15     5           i  I
           16   37     5           i  I
           18   35     6    costPart  D
           19   35     8    bestPart  I
           20   33     9           j  I
           27   31    10        part  Lorg/h2/table/Plan;
           28   31    11     costNow  D

  private void calculateGenetic();
    descriptor: ()V
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=5, locals=5, args_size=1
        start local 0 // org.h2.command.dml.Optimizer this
         0: .line 153
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            arraylength
            anewarray org.h2.table.TableFilter
            astore 1 /* best */
        start local 1 // org.h2.table.TableFilter[] best
         1: .line 154
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            arraylength
            anewarray org.h2.table.TableFilter
            astore 2 /* list */
        start local 2 // org.h2.table.TableFilter[] list
         2: .line 155
            iconst_0
            istore 3 /* x */
        start local 3 // int x
         3: goto 22
         4: .line 156
      StackMap locals: org.h2.table.TableFilter[] org.h2.table.TableFilter[] int
      StackMap stack:
            aload 0 /* this */
            iload 3 /* x */
            invokevirtual org.h2.command.dml.Optimizer.canStop:(I)Z
            ifeq 6
         5: .line 157
            goto 23
         6: .line 159
      StackMap locals:
      StackMap stack:
            iload 3 /* x */
            bipush 127
            iand
            ifne 7
            iconst_1
            goto 8
      StackMap locals:
      StackMap stack:
         7: iconst_0
      StackMap locals:
      StackMap stack: int
         8: istore 4 /* generateRandom */
        start local 4 // boolean generateRandom
         9: .line 160
            iload 4 /* generateRandom */
            ifne 13
        10: .line 161
            aload 1 /* best */
            iconst_0
            aload 2 /* list */
            iconst_0
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            arraylength
            invokestatic java.lang.System.arraycopy:(Ljava/lang/Object;ILjava/lang/Object;II)V
        11: .line 162
            aload 0 /* this */
            aload 2 /* list */
            invokevirtual org.h2.command.dml.Optimizer.shuffleTwo:([Lorg/h2/table/TableFilter;)Z
            ifne 13
        12: .line 163
            iconst_1
            istore 4 /* generateRandom */
        13: .line 166
      StackMap locals: int
      StackMap stack:
            iload 4 /* generateRandom */
            ifeq 18
        14: .line 167
            aload 0 /* this */
            new java.util.BitSet
            dup
            invokespecial java.util.BitSet.<init>:()V
            putfield org.h2.command.dml.Optimizer.switched:Ljava/util/BitSet;
        15: .line 168
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            iconst_0
            aload 1 /* best */
            iconst_0
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            arraylength
            invokestatic java.lang.System.arraycopy:(Ljava/lang/Object;ILjava/lang/Object;II)V
        16: .line 169
            aload 0 /* this */
            aload 1 /* best */
            invokevirtual org.h2.command.dml.Optimizer.shuffleAll:([Lorg/h2/table/TableFilter;)V
        17: .line 170
            aload 1 /* best */
            iconst_0
            aload 2 /* list */
            iconst_0
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            arraylength
            invokestatic java.lang.System.arraycopy:(Ljava/lang/Object;ILjava/lang/Object;II)V
        18: .line 172
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            aload 2 /* list */
            invokevirtual org.h2.command.dml.Optimizer.testPlan:([Lorg/h2/table/TableFilter;)Z
            ifeq 21
        19: .line 173
            aload 0 /* this */
            new java.util.BitSet
            dup
            invokespecial java.util.BitSet.<init>:()V
            putfield org.h2.command.dml.Optimizer.switched:Ljava/util/BitSet;
        20: .line 174
            aload 2 /* list */
            iconst_0
            aload 1 /* best */
            iconst_0
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.filters:[Lorg/h2/table/TableFilter;
            arraylength
            invokestatic java.lang.System.arraycopy:(Ljava/lang/Object;ILjava/lang/Object;II)V
        end local 4 // boolean generateRandom
        21: .line 155
      StackMap locals:
      StackMap stack:
            iinc 3 /* x */ 1
      StackMap locals:
      StackMap stack:
        22: iload 3 /* x */
            sipush 500
            if_icmplt 4
        end local 3 // int x
        23: .line 177
      StackMap locals:
      StackMap stack:
            return
        end local 2 // org.h2.table.TableFilter[] list
        end local 1 // org.h2.table.TableFilter[] best
        end local 0 // org.h2.command.dml.Optimizer this
      LocalVariableTable:
        Start  End  Slot            Name  Signature
            0   24     0            this  Lorg/h2/command/dml/Optimizer;
            1   24     1            best  [Lorg/h2/table/TableFilter;
            2   24     2            list  [Lorg/h2/table/TableFilter;
            3   23     3               x  I
            9   21     4  generateRandom  Z

  private boolean testPlan(org.h2.table.TableFilter[]);
    descriptor: ([Lorg/h2/table/TableFilter;)Z
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=5, locals=5, args_size=2
        start local 0 // org.h2.command.dml.Optimizer this
        start local 1 // org.h2.table.TableFilter[] list
         0: .line 180
            new org.h2.table.Plan
            dup
            aload 1 /* list */
            aload 1 /* list */
            arraylength
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.condition:Lorg/h2/expression/Expression;
            invokespecial org.h2.table.Plan.<init>:([Lorg/h2/table/TableFilter;ILorg/h2/expression/Expression;)V
            astore 2 /* p */
        start local 2 // org.h2.table.Plan p
         1: .line 181
            aload 2 /* p */
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.session:Lorg/h2/engine/Session;
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.allColumnsSet:Lorg/h2/command/dml/AllColumnsForPlan;
            invokevirtual org.h2.table.Plan.calculateCost:(Lorg/h2/engine/Session;Lorg/h2/command/dml/AllColumnsForPlan;)D
            dstore 3 /* costNow */
        start local 3 // double costNow
         2: .line 182
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.cost:D
            dconst_0
            dcmpg
            iflt 3
            dload 3 /* costNow */
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.cost:D
            dcmpg
            ifge 6
         3: .line 183
      StackMap locals: org.h2.table.Plan double
      StackMap stack:
            aload 0 /* this */
            dload 3 /* costNow */
            putfield org.h2.command.dml.Optimizer.cost:D
         4: .line 184
            aload 0 /* this */
            aload 2 /* p */
            putfield org.h2.command.dml.Optimizer.bestPlan:Lorg/h2/table/Plan;
         5: .line 185
            iconst_1
            ireturn
         6: .line 187
      StackMap locals:
      StackMap stack:
            iconst_0
            ireturn
        end local 3 // double costNow
        end local 2 // org.h2.table.Plan p
        end local 1 // org.h2.table.TableFilter[] list
        end local 0 // org.h2.command.dml.Optimizer this
      LocalVariableTable:
        Start  End  Slot     Name  Signature
            0    7     0     this  Lorg/h2/command/dml/Optimizer;
            0    7     1     list  [Lorg/h2/table/TableFilter;
            1    7     2        p  Lorg/h2/table/Plan;
            2    7     3  costNow  D
    MethodParameters:
      Name  Flags
      list  

  private void shuffleAll(org.h2.table.TableFilter[]);
    descriptor: ([Lorg/h2/table/TableFilter;)V
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=4, locals=5, args_size=2
        start local 0 // org.h2.command.dml.Optimizer this
        start local 1 // org.h2.table.TableFilter[] f
         0: .line 191
            iconst_0
            istore 2 /* i */
        start local 2 // int i
         1: goto 8
         2: .line 192
      StackMap locals: int
      StackMap stack:
            iload 2 /* i */
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.random:Ljava/util/Random;
            aload 1 /* f */
            arraylength
            iload 2 /* i */
            isub
            invokevirtual java.util.Random.nextInt:(I)I
            iadd
            istore 3 /* j */
        start local 3 // int j
         3: .line 193
            iload 3 /* j */
            iload 2 /* i */
            if_icmpeq 7
         4: .line 194
            aload 1 /* f */
            iload 2 /* i */
            aaload
            astore 4 /* temp */
        start local 4 // org.h2.table.TableFilter temp
         5: .line 195
            aload 1 /* f */
            iload 2 /* i */
            aload 1 /* f */
            iload 3 /* j */
            aaload
            aastore
         6: .line 196
            aload 1 /* f */
            iload 3 /* j */
            aload 4 /* temp */
            aastore
        end local 4 // org.h2.table.TableFilter temp
        end local 3 // int j
         7: .line 191
      StackMap locals:
      StackMap stack:
            iinc 2 /* i */ 1
      StackMap locals:
      StackMap stack:
         8: iload 2 /* i */
            aload 1 /* f */
            arraylength
            iconst_1
            isub
            if_icmplt 2
        end local 2 // int i
         9: .line 199
            return
        end local 1 // org.h2.table.TableFilter[] f
        end local 0 // org.h2.command.dml.Optimizer this
      LocalVariableTable:
        Start  End  Slot  Name  Signature
            0   10     0  this  Lorg/h2/command/dml/Optimizer;
            0   10     1     f  [Lorg/h2/table/TableFilter;
            1    9     2     i  I
            3    7     3     j  I
            5    7     4  temp  Lorg/h2/table/TableFilter;
    MethodParameters:
      Name  Flags
      f     

  private boolean shuffleTwo(org.h2.table.TableFilter[]);
    descriptor: ([Lorg/h2/table/TableFilter;)Z
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=4, locals=6, args_size=2
        start local 0 // org.h2.command.dml.Optimizer this
        start local 1 // org.h2.table.TableFilter[] f
         0: .line 202
            iconst_0
            istore 2 /* a */
        start local 2 // int a
         1: iconst_0
            istore 3 /* b */
        start local 3 // int b
         2: iconst_0
            istore 4 /* i */
        start local 4 // int i
         3: .line 203
            goto 18
         4: .line 204
      StackMap locals: int int int
      StackMap stack:
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.random:Ljava/util/Random;
            aload 1 /* f */
            arraylength
            invokevirtual java.util.Random.nextInt:(I)I
            istore 2 /* a */
         5: .line 205
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.random:Ljava/util/Random;
            aload 1 /* f */
            arraylength
            invokevirtual java.util.Random.nextInt:(I)I
            istore 3 /* b */
         6: .line 206
            iload 2 /* a */
            iload 3 /* b */
            if_icmpne 8
         7: .line 207
            goto 17
         8: .line 209
      StackMap locals:
      StackMap stack:
            iload 2 /* a */
            iload 3 /* b */
            if_icmpge 12
         9: .line 210
            iload 2 /* a */
            istore 5 /* temp */
        start local 5 // int temp
        10: .line 211
            iload 3 /* b */
            istore 2 /* a */
        11: .line 212
            iload 5 /* temp */
            istore 3 /* b */
        end local 5 // int temp
        12: .line 214
      StackMap locals:
      StackMap stack:
            iload 2 /* a */
            aload 1 /* f */
            arraylength
            imul
            iload 3 /* b */
            iadd
            istore 5 /* s */
        start local 5 // int s
        13: .line 215
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.switched:Ljava/util/BitSet;
            iload 5 /* s */
            invokevirtual java.util.BitSet.get:(I)Z
            ifeq 15
        14: .line 216
            goto 17
        15: .line 218
      StackMap locals: int
      StackMap stack:
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.switched:Ljava/util/BitSet;
            iload 5 /* s */
            invokevirtual java.util.BitSet.set:(I)V
        16: .line 219
            goto 19
        end local 5 // int s
        17: .line 203
      StackMap locals:
      StackMap stack:
            iinc 4 /* i */ 1
      StackMap locals:
      StackMap stack:
        18: iload 4 /* i */
            bipush 20
            if_icmplt 4
        19: .line 221
      StackMap locals:
      StackMap stack:
            iload 4 /* i */
            bipush 20
            if_icmpne 21
        20: .line 222
            iconst_0
            ireturn
        21: .line 224
      StackMap locals:
      StackMap stack:
            aload 1 /* f */
            iload 2 /* a */
            aaload
            astore 5 /* temp */
        start local 5 // org.h2.table.TableFilter temp
        22: .line 225
            aload 1 /* f */
            iload 2 /* a */
            aload 1 /* f */
            iload 3 /* b */
            aaload
            aastore
        23: .line 226
            aload 1 /* f */
            iload 3 /* b */
            aload 5 /* temp */
            aastore
        24: .line 227
            iconst_1
            ireturn
        end local 5 // org.h2.table.TableFilter temp
        end local 4 // int i
        end local 3 // int b
        end local 2 // int a
        end local 1 // org.h2.table.TableFilter[] f
        end local 0 // org.h2.command.dml.Optimizer this
      LocalVariableTable:
        Start  End  Slot  Name  Signature
            0   25     0  this  Lorg/h2/command/dml/Optimizer;
            0   25     1     f  [Lorg/h2/table/TableFilter;
            1   25     2     a  I
            2   25     3     b  I
            3   25     4     i  I
           10   12     5  temp  I
           13   17     5     s  I
           22   25     5  temp  Lorg/h2/table/TableFilter;
    MethodParameters:
      Name  Flags
      f     

  void optimize(boolean);
    descriptor: (Z)V
    flags: (0x0000) 
    Code:
      stack=4, locals=8, args_size=2
        start local 0 // org.h2.command.dml.Optimizer this
        start local 1 // boolean parse
         0: .line 237
            iload 1 /* parse */
            ifeq 3
         1: .line 238
            aload 0 /* this */
            invokevirtual org.h2.command.dml.Optimizer.calculateFakePlan:()V
         2: .line 239
            goto 5
         3: .line 240
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            invokevirtual org.h2.command.dml.Optimizer.calculateBestPlan:()V
         4: .line 241
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.bestPlan:Lorg/h2/table/Plan;
            invokevirtual org.h2.table.Plan.removeUnusableIndexConditions:()V
         5: .line 243
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.bestPlan:Lorg/h2/table/Plan;
            invokevirtual org.h2.table.Plan.getFilters:()[Lorg/h2/table/TableFilter;
            astore 2 /* f2 */
        start local 2 // org.h2.table.TableFilter[] f2
         6: .line 244
            aload 0 /* this */
            aload 2 /* f2 */
            iconst_0
            aaload
            putfield org.h2.command.dml.Optimizer.topFilter:Lorg/h2/table/TableFilter;
         7: .line 245
            iconst_0
            istore 3 /* i */
        start local 3 // int i
         8: goto 11
         9: .line 246
      StackMap locals: org.h2.table.TableFilter[] int
      StackMap stack:
            aload 2 /* f2 */
            iload 3 /* i */
            aaload
            aload 2 /* f2 */
            iload 3 /* i */
            iconst_1
            iadd
            aaload
            iconst_0
            aconst_null
            invokevirtual org.h2.table.TableFilter.addJoin:(Lorg/h2/table/TableFilter;ZLorg/h2/expression/Expression;)V
        10: .line 245
            iinc 3 /* i */ 1
      StackMap locals:
      StackMap stack:
        11: iload 3 /* i */
            aload 2 /* f2 */
            arraylength
            iconst_1
            isub
            if_icmplt 9
        end local 3 // int i
        12: .line 248
            iload 1 /* parse */
            ifeq 14
        13: .line 249
            return
        14: .line 251
      StackMap locals:
      StackMap stack:
            aload 2 /* f2 */
            dup
            astore 6
            arraylength
            istore 5
            iconst_0
            istore 4
            goto 19
      StackMap locals: org.h2.command.dml.Optimizer int org.h2.table.TableFilter[] top int int org.h2.table.TableFilter[]
      StackMap stack:
        15: aload 6
            iload 4
            aaload
            astore 3 /* f */
        start local 3 // org.h2.table.TableFilter f
        16: .line 252
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.bestPlan:Lorg/h2/table/Plan;
            aload 3 /* f */
            invokevirtual org.h2.table.Plan.getItem:(Lorg/h2/table/TableFilter;)Lorg/h2/table/PlanItem;
            astore 7 /* item */
        start local 7 // org.h2.table.PlanItem item
        17: .line 253
            aload 3 /* f */
            aload 7 /* item */
            invokevirtual org.h2.table.TableFilter.setPlanItem:(Lorg/h2/table/PlanItem;)V
        end local 7 // org.h2.table.PlanItem item
        end local 3 // org.h2.table.TableFilter f
        18: .line 251
            iinc 4 1
      StackMap locals:
      StackMap stack:
        19: iload 4
            iload 5
            if_icmplt 15
        20: .line 255
            return
        end local 2 // org.h2.table.TableFilter[] f2
        end local 1 // boolean parse
        end local 0 // org.h2.command.dml.Optimizer this
      LocalVariableTable:
        Start  End  Slot   Name  Signature
            0   21     0   this  Lorg/h2/command/dml/Optimizer;
            0   21     1  parse  Z
            6   21     2     f2  [Lorg/h2/table/TableFilter;
            8   12     3      i  I
           16   18     3      f  Lorg/h2/table/TableFilter;
           17   18     7   item  Lorg/h2/table/PlanItem;
    MethodParameters:
       Name  Flags
      parse  

  public org.h2.table.TableFilter getTopFilter();
    descriptor: ()Lorg/h2/table/TableFilter;
    flags: (0x0001) ACC_PUBLIC
    Code:
      stack=1, locals=1, args_size=1
        start local 0 // org.h2.command.dml.Optimizer this
         0: .line 258
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.topFilter:Lorg/h2/table/TableFilter;
            areturn
        end local 0 // org.h2.command.dml.Optimizer this
      LocalVariableTable:
        Start  End  Slot  Name  Signature
            0    1     0  this  Lorg/h2/command/dml/Optimizer;

  double getCost();
    descriptor: ()D
    flags: (0x0000) 
    Code:
      stack=2, locals=1, args_size=1
        start local 0 // org.h2.command.dml.Optimizer this
         0: .line 262
            aload 0 /* this */
            getfield org.h2.command.dml.Optimizer.cost:D
            dreturn
        end local 0 // org.h2.command.dml.Optimizer this
      LocalVariableTable:
        Start  End  Slot  Name  Signature
            0    1     0  this  Lorg/h2/command/dml/Optimizer;
}
SourceFile: "Optimizer.java"