| JoinCommute |  | 0% | | 0% | 50 | 50 | 62 | 62 | 17 | 17 | 1 | 1 |
| OuterJoinAssocProject | | 0% | | 0% | 22 | 22 | 56 | 56 | 15 | 15 | 1 | 1 |
| OuterJoinLAsscomProject | | 0% | | 0% | 23 | 23 | 52 | 52 | 15 | 15 | 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 | | 94% | | 79% | 7 | 31 | 2 | 63 | 2 | 19 | 0 | 1 |
| PushDownProjectThroughSemiJoin | | 96% | | 50% | 4 | 19 | 2 | 40 | 0 | 14 | 0 | 1 |
| PushDownProjectThroughInnerOuterJoin | | 99% | | 84% | 8 | 49 | 1 | 79 | 0 | 23 | 0 | 1 |
| SemiJoinSemiJoinTransposeProject | | 99% | | 83% | 2 | 20 | 0 | 55 | 0 | 14 | 0 | 1 |
| InnerJoinLAsscomProject | | 100% | | 91% | 2 | 25 | 0 | 57 | 0 | 13 | 0 | 1 |
| InnerJoinRightAssociateProject | | 100% | | 85% | 3 | 21 | 0 | 42 | 0 | 11 | 0 | 1 |
| InnerJoinLeftAssociateProject | | 100% | | 80% | 4 | 21 | 0 | 42 | 0 | 11 | 0 | 1 |