Aggregate: LeftAnti join no pushdown | 9 ms | Passed |
Aggregate: LeftSemi join partial pushdown | 15 ms | Passed |
Aggregate: LeftSemiAnti join no pushdown due to non-deterministic aggr expressions | 5 ms | Passed |
Aggregate: LeftSemiAnti join non-correlated scalar subq aggr exprs | 12 ms | Passed |
Aggregate: LeftSemiAnti join pushdown | 11 ms | Passed |
LeftAnti no pushdown - join condition refers both leg - join type Cross | 5 ms | Passed |
LeftAnti no pushdown - join condition refers both leg - join type Inner | 6 ms | Passed |
LeftAnti no pushdown - join condition refers both leg - join type LeftOuter | 6 ms | Passed |
LeftAnti no pushdown - join condition refers both leg - join type RightOuter | 6 ms | Passed |
LeftAnti no pushdown - join condition refers left leg - join type for RightOuter | 5 ms | Passed |
LeftAnti no pushdown - join condition refers none of the leg - join type Cross | 5 ms | Passed |
LeftAnti no pushdown - join condition refers none of the leg - join type Inner | 6 ms | Passed |
LeftAnti no pushdown - join condition refers none of the leg - join type LeftOuter | 5 ms | Passed |
LeftAnti no pushdown - join condition refers none of the leg - join type RightOuter | 5 ms | Passed |
LeftAnti no pushdown - join condition refers right leg - join type for LeftOuter | 5 ms | Passed |
LeftAnti no pushdown when child join type is FullOuter | 5 ms | Passed |
LeftAnti pushdown empty join cond join type Cross join cond None | 2 ms | Passed |
LeftAnti pushdown empty join cond join type Cross join cond Some(('d = 'e)) | 4 ms | Passed |
LeftAnti pushdown empty join cond join type Inner join cond None | 3 ms | Passed |
LeftAnti pushdown empty join cond join type Inner join cond Some(('d = 'e)) | 4 ms | Passed |
LeftAnti pushdown empty join cond join type LeftOuter join cond None | 3 ms | Passed |
LeftAnti pushdown empty join cond join type LeftOuter join cond Some(('d = 'e)) | 4 ms | Passed |
LeftAnti pushdown empty join cond join type RightOuter join cond None | 2 ms | Passed |
LeftAnti pushdown empty join cond join type RightOuter join cond Some(('d = 'e)) | 4 ms | Passed |
LeftAnti pushdown to left of join type: Cross join condition None | 6 ms | Passed |
LeftAnti pushdown to left of join type: Cross join condition Some(('d = 'e)) | 7 ms | Passed |
LeftAnti pushdown to left of join type: Inner join condition None | 6 ms | Passed |
LeftAnti pushdown to left of join type: Inner join condition Some(('d = 'e)) | 4 ms | Passed |
LeftAnti pushdown to left of join type: LeftOuter join condition None | 6 ms | Passed |
LeftAnti pushdown to left of join type: LeftOuter join condition Some(('d = 'e)) | 6 ms | Passed |
LeftAnti pushdown to right of join type: Cross join condition None | 5 ms | Passed |
LeftAnti pushdown to right of join type: Cross join condition Some(('e = 'd)) | 7 ms | Passed |
LeftAnti pushdown to right of join type: Inner join condition None | 6 ms | Passed |
LeftAnti pushdown to right of join type: Inner join condition Some(('e = 'd)) | 7 ms | Passed |
LeftAnti pushdown to right of join type: RightOuter join condition None | 6 ms | Passed |
LeftAnti pushdown to right of join type: RightOuter join condition Some(('e = 'd)) | 7 ms | Passed |
LeftSemi no pushdown - join condition refers both leg - join type Cross | 6 ms | Passed |
LeftSemi no pushdown - join condition refers both leg - join type Inner | 6 ms | Passed |
LeftSemi no pushdown - join condition refers both leg - join type LeftOuter | 5 ms | Passed |
LeftSemi no pushdown - join condition refers both leg - join type RightOuter | 5 ms | Passed |
LeftSemi no pushdown - join condition refers left leg - join type for RightOuter | 5 ms | Passed |
LeftSemi no pushdown - join condition refers none of the leg - join type Cross | 5 ms | Passed |
LeftSemi no pushdown - join condition refers none of the leg - join type Inner | 6 ms | Passed |
LeftSemi no pushdown - join condition refers none of the leg - join type LeftOuter | 5 ms | Passed |
LeftSemi no pushdown - join condition refers none of the leg - join type RightOuter | 6 ms | Passed |
LeftSemi no pushdown - join condition refers right leg - join type for LeftOuter | 5 ms | Passed |
LeftSemi no pushdown when child join type is FullOuter | 6 ms | Passed |
LeftSemi pushdown empty join cond join type Cross join cond None | 3 ms | Passed |
LeftSemi pushdown empty join cond join type Cross join cond Some(('d = 'e)) | 4 ms | Passed |
LeftSemi pushdown empty join cond join type Inner join cond None | 3 ms | Passed |
LeftSemi pushdown empty join cond join type Inner join cond Some(('d = 'e)) | 5 ms | Passed |
LeftSemi pushdown empty join cond join type LeftOuter join cond None | 3 ms | Passed |
LeftSemi pushdown empty join cond join type LeftOuter join cond Some(('d = 'e)) | 4 ms | Passed |
LeftSemi pushdown empty join cond join type RightOuter join cond None | 3 ms | Passed |
LeftSemi pushdown empty join cond join type RightOuter join cond Some(('d = 'e)) | 4 ms | Passed |
LeftSemi pushdown to left of join type: Cross join condition None | 6 ms | Passed |
LeftSemi pushdown to left of join type: Cross join condition Some(('d = 'e)) | 4 ms | Passed |
LeftSemi pushdown to left of join type: Inner join condition None | 7 ms | Passed |
LeftSemi pushdown to left of join type: Inner join condition Some(('d = 'e)) | 7 ms | Passed |
LeftSemi pushdown to left of join type: LeftOuter join condition None | 7 ms | Passed |
LeftSemi pushdown to left of join type: LeftOuter join condition Some(('d = 'e)) | 5 ms | Passed |
LeftSemi pushdown to right of join type: Cross join condition None | 6 ms | Passed |
LeftSemi pushdown to right of join type: Cross join condition Some(('e = 'd)) | 7 ms | Passed |
LeftSemi pushdown to right of join type: Inner join condition None | 6 ms | Passed |
LeftSemi pushdown to right of join type: Inner join condition Some(('e = 'd)) | 8 ms | Passed |
LeftSemi pushdown to right of join type: RightOuter join condition None | 6 ms | Passed |
LeftSemi pushdown to right of join type: RightOuter join condition Some(('e = 'd)) | 7 ms | Passed |
LeftSemiAnti join over Window | 16 ms | Passed |
LeftSemiAnti join over aggregate - no pushdown | 8 ms | Passed |
Project: LeftSemiAnti join no pushdown - correlated scalar subq in projection list | 26 ms | Passed |
Project: LeftSemiAnti join no pushdown because of non-deterministic proj exprs | 6 ms | Passed |
Project: LeftSemiAnti join non correlated scalar subq | 11 ms | Passed |
Project: LeftSemiAnti join pushdown | 11 ms | Passed |
Unary: LeftAnti join pushdown - no pushdown | 7 ms | Passed |
Unary: LeftSemi join pushdown - partial pushdown | 9 ms | Passed |
Unary: LeftSemiAnti join pushdown | 8 ms | Passed |
Unary: LeftSemiAnti join pushdown - empty join condition | 5 ms | Passed |
Unary: LeftSemiAnti join pushdown - no pushdown | 7 ms | Passed |
Union: LeftSemiAnti join no pushdown in self join scenario | 5 ms | Passed |
Union: LeftSemiAnti join pushdown | 10 ms | Passed |
Window: LeftAnti no pushdown | 14 ms | Passed |
Window: LeftSemi partial pushdown | 15 ms | Passed |