SQL EXPLAIN: Index-related columns

These relate to the usage of indexes:

  1.  possible_keys
    • Which indexes were considered?
  2. key
    • Which indexes did the optimizer choose?
  3.  key_len
    • How many bytes of the index will be used?