Inner join two large files using limited RAM
Filed under MakeMyTrip
The question
Given 16 GB RAM, 256 GB hard disk, a customer file of 100MB, and an order file of 200GB, write an SQL query or code in any language to perform an inner join between these two files based on customer ID under hardware constraints.
No write-up yet. Related questions below have one.
Related MakeMyTrip questions
Collected from public candidate posts and coding forums. Updated Nov 2026.