I swear there are 10 ways to write any given SQL query, but only 1 of them performs well.