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

Output plans (best plan 7):
0.(284.437)[111] INLJ
 -> left:
    (12.4633)[011] INLJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        [010][test.nss1] INDEX_PROBE { a1: 1 }
 -> right:
    [100][test.nss2] INDEX_PROBE { a2: -1 }

1.(276.554)[111] INLJ
 -> left:
    (4.57993)[011] HJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        (3.30485)[010][test.nss1] COLLSCAN
 -> right:
    [100][test.nss2] INDEX_PROBE { a2: -1 }

2.(311.854)[111] INLJ
 -> left:
    (39.8806)[011] NLJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        (3.30485)[010][test.nss1] COLLSCAN
 -> right:
    [100][test.nss2] INDEX_PROBE { a2: -1 }

3.(277.862)[111] INLJ
 -> left:
    (5.88805)[011] INLJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        [001][test.nss0] INDEX_PROBE { a0: -1 }
 -> right:
    [100][test.nss2] INDEX_PROBE { a2: -1 }

4.(276.554)[111] INLJ
 -> left:
    (4.57993)[011] HJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        (0.0327213)[001][test.nss0] COLLSCAN
 -> right:
    [100][test.nss2] INDEX_PROBE { a2: -1 }

5.(315.127)[111] INLJ
 -> left:
    (43.1527)[011] NLJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        (0.0327213)[001][test.nss0] COLLSCAN
 -> right:
    [100][test.nss2] INDEX_PROBE { a2: -1 }

6.(145.131)[111] HJ
 -> left:
    (12.4633)[011] INLJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        [010][test.nss1] INDEX_PROBE { a1: 1 }
 -> right:
    (6.57698)[100][test.nss2] COLLSCAN

7.(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

8.(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

9.(138.555)[111] HJ
 -> left:
    (5.88805)[011] INLJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        [001][test.nss0] INDEX_PROBE { a0: -1 }
 -> right:
    (6.57698)[100][test.nss2] COLLSCAN

10.(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

11.(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

12.(8021.88)[111] NLJ
 -> left:
    (12.4633)[011] INLJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        [010][test.nss1] INDEX_PROBE { a1: 1 }
 -> right:
    (6.57698)[100][test.nss2] COLLSCAN

13.(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

14.(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

15.(8015.3)[111] NLJ
 -> left:
    (5.88805)[011] INLJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        [001][test.nss0] INDEX_PROBE { a0: -1 }
 -> right:
    (6.57698)[100][test.nss2] COLLSCAN

16.(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

17.(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

18.(145.131)[111] HJ
 -> left:
    (6.57698)[100][test.nss2] COLLSCAN
 -> right:
    (12.4633)[011] INLJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        [010][test.nss1] INDEX_PROBE { a1: 1 }

19.(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

20.(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

21.(138.555)[111] HJ
 -> left:
    (6.57698)[100][test.nss2] COLLSCAN
 -> right:
    (5.88805)[011] INLJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        [001][test.nss0] INDEX_PROBE { a0: -1 }

22.(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

23.(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

24.(286.885)[111] INLJ
 -> left:
    (24.7586)[101] INLJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        [100][test.nss2] INDEX_PROBE { a2: -1 }
 -> right:
    [010][test.nss1] INDEX_PROBE { a1: 1 }

25.(271.203)[111] INLJ
 -> left:
    (9.07606)[101] HJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        (6.57698)[100][test.nss2] COLLSCAN
 -> right:
    [010][test.nss1] INDEX_PROBE { a1: 1 }

26.(341.46)[111] INLJ
 -> left:
    (79.3339)[101] NLJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        (6.57698)[100][test.nss2] COLLSCAN
 -> right:
    [010][test.nss1] INDEX_PROBE { a1: 1 }

27.(273.735)[111] INLJ
 -> left:
    (11.6082)[101] INLJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        [001][test.nss0] INDEX_PROBE { a0: -1 }
 -> right:
    [010][test.nss1] INDEX_PROBE { a1: 1 }

28.(271.203)[111] INLJ
 -> left:
    (9.07606)[101] HJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        (0.0327213)[001][test.nss0] COLLSCAN
 -> right:
    [010][test.nss1] INDEX_PROBE { a1: 1 }

29.(348.005)[111] INLJ
 -> left:
    (85.8781)[101] NLJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        (0.0327213)[001][test.nss0] COLLSCAN
 -> right:
    [010][test.nss1] INDEX_PROBE { a1: 1 }

30.(154.154)[111] HJ
 -> left:
    (24.7586)[101] INLJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        [100][test.nss2] INDEX_PROBE { a2: -1 }
 -> right:
    (3.30485)[010][test.nss1] COLLSCAN

31.(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

32.(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

33.(141.003)[111] HJ
 -> left:
    (11.6082)[101] INLJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        [001][test.nss0] INDEX_PROBE { a0: -1 }
 -> right:
    (3.30485)[010][test.nss1] COLLSCAN

34.(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

35.(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

36.(8034.17)[111] NLJ
 -> left:
    (24.7586)[101] INLJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        [100][test.nss2] INDEX_PROBE { a2: -1 }
 -> right:
    (3.30485)[010][test.nss1] COLLSCAN

37.(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

38.(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

39.(8021.02)[111] NLJ
 -> left:
    (11.6082)[101] INLJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        [001][test.nss0] INDEX_PROBE { a0: -1 }
 -> right:
    (3.30485)[010][test.nss1] COLLSCAN

40.(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

41.(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

42.(154.154)[111] HJ
 -> left:
    (3.30485)[010][test.nss1] COLLSCAN
 -> right:
    (24.7586)[101] INLJ
     -> left:
        (0.0327213)[001][test.nss0] COLLSCAN
     -> right:
        [100][test.nss2] INDEX_PROBE { a2: -1 }

43.(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

44.(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

45.(141.003)[111] HJ
 -> left:
    (3.30485)[010][test.nss1] COLLSCAN
 -> right:
    (11.6082)[101] INLJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        [001][test.nss0] INDEX_PROBE { a0: -1 }

46.(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

47.(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

48.(772.358)[111] INLJ
 -> left:
    (275.279)[110] INLJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        [100][test.nss2] INDEX_PROBE { a2: -1 }
 -> right:
    [001][test.nss0] INDEX_PROBE { a0: -1 }

49.(633.051)[111] INLJ
 -> left:
    (135.972)[110] HJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        (6.57698)[100][test.nss2] COLLSCAN
 -> right:
    [001][test.nss0] INDEX_PROBE { a0: -1 }

50.(8509.8)[111] INLJ
 -> left:
    (8012.72)[110] NLJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        (6.57698)[100][test.nss2] COLLSCAN
 -> right:
    [001][test.nss0] INDEX_PROBE { a0: -1 }

51.(765.783)[111] INLJ
 -> left:
    (268.704)[110] INLJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        [010][test.nss1] INDEX_PROBE { a1: 1 }
 -> right:
    [001][test.nss0] INDEX_PROBE { a0: -1 }

52.(633.051)[111] INLJ
 -> left:
    (135.972)[110] HJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        (3.30485)[010][test.nss1] COLLSCAN
 -> right:
    [001][test.nss0] INDEX_PROBE { a0: -1 }

53.(8513.07)[111] INLJ
 -> left:
    (8015.99)[110] NLJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        (3.30485)[010][test.nss1] COLLSCAN
 -> right:
    [001][test.nss0] INDEX_PROBE { a0: -1 }

54.(1212.15)[111] HJ
 -> left:
    (275.279)[110] INLJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        [100][test.nss2] INDEX_PROBE { a2: -1 }
 -> right:
    (0.0327213)[001][test.nss0] COLLSCAN

55.(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

56.(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

57.(1205.58)[111] HJ
 -> left:
    (268.704)[110] INLJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        [010][test.nss1] INDEX_PROBE { a1: 1 }
 -> right:
    (0.0327213)[001][test.nss0] COLLSCAN

58.(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

59.(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

60.(8284.69)[111] NLJ
 -> left:
    (275.279)[110] INLJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        [100][test.nss2] INDEX_PROBE { a2: -1 }
 -> right:
    (0.0327213)[001][test.nss0] COLLSCAN

61.(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

62.(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

63.(8278.12)[111] NLJ
 -> left:
    (268.704)[110] INLJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        [010][test.nss1] INDEX_PROBE { a1: 1 }
 -> right:
    (0.0327213)[001][test.nss0] COLLSCAN

64.(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

65.(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

66.(523.802)[111] HJ
 -> left:
    (0.0327213)[001][test.nss0] COLLSCAN
 -> right:
    (275.279)[110] INLJ
     -> left:
        (3.30485)[010][test.nss1] COLLSCAN
     -> right:
        [100][test.nss2] INDEX_PROBE { a2: -1 }

67.(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

68.(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

69.(517.227)[111] HJ
 -> left:
    (0.0327213)[001][test.nss0] COLLSCAN
 -> right:
    (268.704)[110] INLJ
     -> left:
        (6.57698)[100][test.nss2] COLLSCAN
     -> right:
        [010][test.nss1] INDEX_PROBE { a1: 1 }

70.(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

71.(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

