This background information helps you to understand some of the terms you see in the
EXPLAIN plan output. If you are rewriting queries to make them more efficient, or
writing your own application logic for lookups, joining, or sorting, use this information to determine which
optimizations you write yourself and which you can rely on MySQL to perform.