I think a better maxim would be to never have an un-indexed ORDER BY or JOIN. A big part of what many "nosql" databases that prioritize scale are doing is simp

I think a better maxim would be to never have an un-indexed ORDER BY or JOIN. A big part of what many "nosql" databases that prioritize scale are doing is simply preventing you from ever running an adhoc un-indexed query.