[cornel_io]

NB: this post is mostly performance advice, and it only applies to traditional databases. Specifically, it is not good advice for big data columnar DBs, for instance a limit clause doesn't help you at all on BigQuery and grabbing fewer columns really does.

[jitans]

not even all the "traditional" databases, each Engine has his own peculiarities.