Displays the attributes of the columns defined by a particular join index.
Privileges
You must either own the tables on which the join index is defined or have at least one privilege on each of those tables.
Use the SHOW privilege to enable a user to perform HELP or SHOW requests only against a specified join index.