most query optimization techniques are designed to make the optimizer’s work easier. what factors should you keep in mind if you intend to write conditional expressions in sql code?