medium10 pts · first answer countshash-mapjoinsperformance
Joining two lists in memory
You join 5,000 branch records with 20 lakh transactions on branch_id in application code. What is the efficient approach?
Discussion 0
Join free to post in the discussion.
Related questions
- Rows returned by a LEFT JOINBackend Developer
- Slow email during signupBackend Developer
- What EXPLAIN tells youBackend Developer
- Asking for only a few fieldsBackend Developer
- Building a long string in a loopBackend Developer
- Checking if any rows existBackend Developer
- Average cost of a hash map lookupBackend Developer
- Worst case for a hash map lookupBackend Developer