Embed Notice

@revk I'll never forget an SQL optimisation moment near the start of my career.

There was a report whose query would run for well over 11 hours (this was in 1997 or so), and was usually interrupted by the DBMS being shutdown for the nightly backups.

One day, I took a closer look at the query, and realised two tables had been joined in the wrong order. Fixed that, and it completed in under 5 minutes.