โ† MakeMyTrip questions

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.