LEFT DEEP, 3 Nodes
HJ order pruning enabled: 0
Level 0:
001, 010, 100
Level 1:
011, 101, 110
Level 2:
111

Output plans (best plan 0):
0.(137.247)[111] HJ
 -> left:
    (4.57993)[011] HJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        (3.30485)[010][test.nss1] COLLSCAN
 -> right:
    (6.57698)[100][test.nss2] COLLSCAN

RIGHT DEEP, 3 Nodes
HJ order pruning enabled: 0
Level 0:
001, 010, 100
Level 1:
011, 101, 110
Level 2:
111

Output plans (best plan 0):
0.(137.247)[111] HJ
 -> left:
    (6.57698)[100][test.nss2] COLLSCAN
 -> right:
    (4.57993)[011] HJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        (3.30485)[010][test.nss1] COLLSCAN

ZIG ZAG, 3 Nodes
HJ order pruning enabled: 0
Level 0:
001, 010, 100
Level 1:
011, 101, 110
Level 2:
111

Output plans (best plan 0):
0.(137.247)[111] HJ
 -> left:
    (4.57993)[011] HJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        (3.30485)[010][test.nss1] COLLSCAN
 -> right:
    (6.57698)[100][test.nss2] COLLSCAN

All plans enumeration mode
HJ order pruning enabled: 0
Level 0:
001, 010, 100
Level 1:
011, 101, 110
Level 2:
111

Output plans (best plan 0):
0.(137.247)[111] HJ
 -> left:
    (4.57993)[011] HJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        (3.30485)[010][test.nss1] COLLSCAN
 -> right:
    (6.57698)[100][test.nss2] COLLSCAN

1.(172.548)[111] HJ
 -> left:
    (39.8806)[011] NLJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        (3.30485)[010][test.nss1] COLLSCAN
 -> right:
    (6.57698)[100][test.nss2] COLLSCAN

2.(137.247)[111] HJ
 -> left:
    (4.57993)[011] HJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        (0.0327213)[001][test.nss0] COLLSCAN
 -> right:
    (6.57698)[100][test.nss2] COLLSCAN

3.(175.82)[111] HJ
 -> left:
    (43.1527)[011] NLJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        (0.0327213)[001][test.nss0] COLLSCAN
 -> right:
    (6.57698)[100][test.nss2] COLLSCAN

4.(8014)[111] NLJ
 -> left:
    (4.57993)[011] HJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        (3.30485)[010][test.nss1] COLLSCAN
 -> right:
    (6.57698)[100][test.nss2] COLLSCAN

5.(8049.3)[111] NLJ
 -> left:
    (39.8806)[011] NLJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        (3.30485)[010][test.nss1] COLLSCAN
 -> right:
    (6.57698)[100][test.nss2] COLLSCAN

6.(8014)[111] NLJ
 -> left:
    (4.57993)[011] HJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        (0.0327213)[001][test.nss0] COLLSCAN
 -> right:
    (6.57698)[100][test.nss2] COLLSCAN

7.(8052.57)[111] NLJ
 -> left:
    (43.1527)[011] NLJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        (0.0327213)[001][test.nss0] COLLSCAN
 -> right:
    (6.57698)[100][test.nss2] COLLSCAN

8.(137.247)[111] HJ
 -> left:
    (6.57698)[100][test.nss2] COLLSCAN
 -> right:
    (4.57993)[011] HJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        (3.30485)[010][test.nss1] COLLSCAN

9.(172.548)[111] HJ
 -> left:
    (6.57698)[100][test.nss2] COLLSCAN
 -> right:
    (39.8806)[011] NLJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        (3.30485)[010][test.nss1] COLLSCAN

10.(137.247)[111] HJ
 -> left:
    (6.57698)[100][test.nss2] COLLSCAN
 -> right:
    (4.57993)[011] HJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        (0.0327213)[001][test.nss0] COLLSCAN

11.(175.82)[111] HJ
 -> left:
    (6.57698)[100][test.nss2] COLLSCAN
 -> right:
    (43.1527)[011] NLJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        (0.0327213)[001][test.nss0] COLLSCAN

12.(138.471)[111] HJ
 -> left:
    (9.07606)[101] HJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        (6.57698)[100][test.nss2] COLLSCAN
 -> right:
    (3.30485)[010][test.nss1] COLLSCAN

13.(208.729)[111] HJ
 -> left:
    (79.3339)[101] NLJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        (6.57698)[100][test.nss2] COLLSCAN
 -> right:
    (3.30485)[010][test.nss1] COLLSCAN

14.(138.471)[111] HJ
 -> left:
    (9.07606)[101] HJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        (0.0327213)[001][test.nss0] COLLSCAN
 -> right:
    (3.30485)[010][test.nss1] COLLSCAN

15.(215.273)[111] HJ
 -> left:
    (85.8781)[101] NLJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        (0.0327213)[001][test.nss0] COLLSCAN
 -> right:
    (3.30485)[010][test.nss1] COLLSCAN

16.(8018.49)[111] NLJ
 -> left:
    (9.07606)[101] HJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        (6.57698)[100][test.nss2] COLLSCAN
 -> right:
    (3.30485)[010][test.nss1] COLLSCAN

17.(8088.75)[111] NLJ
 -> left:
    (79.3339)[101] NLJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        (6.57698)[100][test.nss2] COLLSCAN
 -> right:
    (3.30485)[010][test.nss1] COLLSCAN

18.(8018.49)[111] NLJ
 -> left:
    (9.07606)[101] HJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        (0.0327213)[001][test.nss0] COLLSCAN
 -> right:
    (3.30485)[010][test.nss1] COLLSCAN

19.(8095.29)[111] NLJ
 -> left:
    (85.8781)[101] NLJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        (0.0327213)[001][test.nss0] COLLSCAN
 -> right:
    (3.30485)[010][test.nss1] COLLSCAN

20.(138.471)[111] HJ
 -> left:
    (3.30485)[010][test.nss1] COLLSCAN
 -> right:
    (9.07606)[101] HJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        (6.57698)[100][test.nss2] COLLSCAN

21.(208.729)[111] HJ
 -> left:
    (3.30485)[010][test.nss1] COLLSCAN
 -> right:
    (79.3339)[101] NLJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        (6.57698)[100][test.nss2] COLLSCAN

22.(138.471)[111] HJ
 -> left:
    (3.30485)[010][test.nss1] COLLSCAN
 -> right:
    (9.07606)[101] HJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        (0.0327213)[001][test.nss0] COLLSCAN

23.(215.273)[111] HJ
 -> left:
    (3.30485)[010][test.nss1] COLLSCAN
 -> right:
    (85.8781)[101] NLJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        (0.0327213)[001][test.nss0] COLLSCAN

24.(1072.85)[111] HJ
 -> left:
    (135.972)[110] HJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        (6.57698)[100][test.nss2] COLLSCAN
 -> right:
    (0.0327213)[001][test.nss0] COLLSCAN

25.(8949.6)[111] HJ
 -> left:
    (8012.72)[110] NLJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        (6.57698)[100][test.nss2] COLLSCAN
 -> right:
    (0.0327213)[001][test.nss0] COLLSCAN

26.(1072.85)[111] HJ
 -> left:
    (135.972)[110] HJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        (3.30485)[010][test.nss1] COLLSCAN
 -> right:
    (0.0327213)[001][test.nss0] COLLSCAN

27.(8952.87)[111] HJ
 -> left:
    (8015.99)[110] NLJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        (3.30485)[010][test.nss1] COLLSCAN
 -> right:
    (0.0327213)[001][test.nss0] COLLSCAN

28.(8145.39)[111] NLJ
 -> left:
    (135.972)[110] HJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        (6.57698)[100][test.nss2] COLLSCAN
 -> right:
    (0.0327213)[001][test.nss0] COLLSCAN

29.(16022.1)[111] NLJ
 -> left:
    (8012.72)[110] NLJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        (6.57698)[100][test.nss2] COLLSCAN
 -> right:
    (0.0327213)[001][test.nss0] COLLSCAN

30.(8145.39)[111] NLJ
 -> left:
    (135.972)[110] HJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        (3.30485)[010][test.nss1] COLLSCAN
 -> right:
    (0.0327213)[001][test.nss0] COLLSCAN

31.(16025.4)[111] NLJ
 -> left:
    (8015.99)[110] NLJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        (3.30485)[010][test.nss1] COLLSCAN
 -> right:
    (0.0327213)[001][test.nss0] COLLSCAN

32.(384.495)[111] HJ
 -> left:
    (0.0327213)[001][test.nss0] COLLSCAN
 -> right:
    (135.972)[110] HJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        (6.57698)[100][test.nss2] COLLSCAN

33.(8261.24)[111] HJ
 -> left:
    (0.0327213)[001][test.nss0] COLLSCAN
 -> right:
    (8012.72)[110] NLJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        (6.57698)[100][test.nss2] COLLSCAN

34.(384.495)[111] HJ
 -> left:
    (0.0327213)[001][test.nss0] COLLSCAN
 -> right:
    (135.972)[110] HJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        (3.30485)[010][test.nss1] COLLSCAN

35.(8264.52)[111] HJ
 -> left:
    (0.0327213)[001][test.nss0] COLLSCAN
 -> right:
    (8015.99)[110] NLJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        (3.30485)[010][test.nss1] COLLSCAN

