Lecture 11 - Query Optimization II - University of Cyprus

Block-Nested Loop Join (BNLJ) .... We will ignore output costs (as always) as the results are ... A) Tuple-at-a-time Nested Loops join: Scan outer relation R,.

www.cs.ucy.ac.cy