mysql> explain performances;
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| PerfId      | int(11)      | NO   | PRI | NULL    | auto_increment |
| Date        | datetime     | NO   |     |         |                |
| MovieName   | varchar(255) | NO   | MUL |         |                |
| TheaterName | varchar(255) | NO   | MUL |         |                |
+-------------+--------------+------+-----+---------+----------------+
4 rows in set (0.07 sec)