Index design is the primary tool for influencing access plans. Understanding EXPLAIN output tells you which indexes are needed and how they are being used.