SQL
2 pieces of work and writing on this site touch sql.
Case studyPayment Distribution Engine30–40 min → 6–8 min per cycleDecisionHow do you query a billion-row transaction table without falling over?Bound every access by a key range, keep the access path matched to an existing index, and stop treating COUNT(*) as free.