Optimizing the Wrong Code

Today I was going through some of our worst queries on Skylight and trying to find some low-hanging fruit to improve performance with the least effort possible. I like Skylight because it's a tool designed to reduce noise. Whenever you get into the optimization mindset, noise is your worst enemy. It turns the most innocent pursuit of necessary speed improvements into a rabbit hole chase of diminishing gains.