# Sql Tuning Principles (E)

+ Try to avoid complex query (multi-table join, subquery, etc.)
  + Drive large result sets with small result sets
  + The column involved in the WHERE predicate in the join should have an index
  + Try to use**INNER JOIN** for multi-table join
  + You can specify the order of joins using the**STRAIGHT_JOIN** option
------------------------------------------------------------
[no notes]