Given a query that is misbehaving ( due to its author im sure ( me )). I ran it with explain and profile but am having a hard time deciphering what i'm seeing into actionable improvements. I wasn't able to find a lot of in-depth docs on the topic.
A...