We participate in the Amazon Service LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com

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?