Hacker News new | ask | show | jobs
by andersmurphy 52 days ago
Although not as prominent as insert SELECT and UPDATE both benefit from page cache locality, assuming rows that are stored near each other are often selected/updated together.