Know what you code
Roughly, how many rows should
the query return? Is that a useful result set (not
too large for human consumption)?
Does the query return any rows or columns
that arent really needed?
When, and how often, does the query run?
Can it perform well in that context, given reasonable per-row
performance, or do we have an example of an unsolvable tuning
problem?