When MongoDB’s closest competitor Couchbase was looking for a query language to replace their Java-based mapreduce framework, they created their own SQL dialect.

Want faster SQL queries? Here are nine best practices for writing SQL queries that work like a charm (or at least, like they should).