All of the following are guidelines for better query design EXCEPT:

understand how indexes are used in query processing.

use a lot of self$-$joins.

write simple queries.

retrieve only the data that you need.