This background information helps you to understand some of the
terms you see in the
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.