Know your data: I often see queries where a developer has taken a crazy route to get to some data where a much simpler path could have been used. This is often the result of bad schema design choices. Understand real-world use patterns: Understand how will the data actually be queried. Does your schema support [...]
