Northern Trust Interview Question

Query optimization in SQL Joins Architecture 12c