I make sure to understand the query to the fullest extent. I run explain plan to make sure no nasty things like full table scans are happening.

I guess just like any algorithm it’s easier to verify a solution than come up with one.