| JoinCommute |  | 0% | | 0% | 43 | 43 | 50 | 50 | 16 | 16 | 1 | 1 |
| JoinExchangeBothProject |  | 68% | | 64% | 16 | 33 | 15 | 67 | 3 | 12 | 0 | 1 |
| JoinCommute.SwapType | | 0% | | n/a | 1 | 1 | 3 | 3 | 1 | 1 | 1 | 1 |
| JoinReorderContext | | 82% | | n/a | 1 | 18 | 8 | 47 | 1 | 18 | 0 | 1 |
| LogicalJoinSemiJoinTransposeProject | | 96% | | 79% | 6 | 31 | 1 | 63 | 1 | 19 | 0 | 1 |
| PushDownProjectThroughSemiJoin | | 96% | | 50% | 4 | 19 | 2 | 40 | 0 | 14 | 0 | 1 |
| OuterJoinAssocProject | | 98% | | 64% | 5 | 22 | 1 | 56 | 0 | 15 | 0 | 1 |
| SemiJoinSemiJoinTransposeProject | | 99% | | 83% | 2 | 20 | 0 | 55 | 0 | 14 | 0 | 1 |
| InnerJoinLeftAssociateProject | | 99% | | 75% | 5 | 21 | 0 | 42 | 0 | 11 | 0 | 1 |
| PushDownProjectThroughInnerOuterJoin | | 99% | | 81% | 12 | 56 | 0 | 85 | 0 | 23 | 0 | 1 |
| InnerJoinLAsscomProject | | 100% | | 91% | 2 | 25 | 0 | 57 | 0 | 13 | 0 | 1 |
| OuterJoinLAsscomProject | | 100% | | 87% | 2 | 23 | 0 | 52 | 0 | 15 | 0 | 1 |
| InnerJoinRightAssociateProject | | 100% | | 80% | 4 | 21 | 0 | 42 | 0 | 11 | 0 | 1 |