In SQL Tuning, the author describes a diagram-based method for tuning SQL statements. This method is not iterative and random, but rather is deterministic: you follow a well-defined process once, and at the end of that process you will know the optimal, or at least the near-optimal, execution plan for the statement in question.