Today I Learned

count(*) is actually faster than count(1). I’d been taught the opposite long ago. 🤦‍♀️

Also, group by 1 means group by the first column. Don’t use it. Be explicit instead.