Level 7 - ArchitectOutput Prediction Questionsm2 query shape optimization
Output: EXISTS vs JOIN+DISTINCT Row Semantics
If one customer has 3 matching orders, how many rows should an EXISTS-based query return for that customer?
If one customer has 3 matching orders, how many rows should an EXISTS-based query return for that customer?