Northern Trust interview question

Query optimization in SQL Joins Architecture 12c