MariaDB [m]> source Q7-analyze.sql
+------+-------------+----------+--------+-------------------------------------+---------+---------+------------------------+---------+------------+----------+------------+----------------------------------------------+
| id   | select_type | table    | type   | possible_keys                       | key     | key_len | ref                    | rows    | r_rows     | filtered | r_filtered | Extra                                        |
+------+-------------+----------+--------+-------------------------------------+---------+---------+------------------------+---------+------------+----------+------------+----------------------------------------------+
|    1 | SIMPLE      | LINEITEM | ALL    | PRIMARY,IDX_LINEITEM_ORDERKEY_FKIDX | NULL    | NULL    | NULL                   | 5082399 | 6000281.00 |   100.00 |      30.41 | Using where; Using temporary; Using filesort |
|    1 | SIMPLE      | SUPPLIER | eq_ref | PRIMARY,SUPPLIER_NATION_FKIDX       | PRIMARY | 4       | m.LINEITEM.L_SUPPKEY   | 1       | 1.00       |   100.00 |     100.00 | Using where                                  |
|    1 | SIMPLE      | ORDERS   | eq_ref | PRIMARY,ORDERS_FK1                  | PRIMARY | 8       | m.LINEITEM.L_ORDERKEY  | 1       | 1.00       |   100.00 |     100.00 |                                              |
|    1 | SIMPLE      | CUSTOMER | eq_ref | PRIMARY,CUSTOMER_NATION_FKIDX       | PRIMARY | 4       | m.ORDERS.O_CUSTKEY     | 1       | 1.00       |   100.00 |     100.00 | Using where                                  |
|    1 | SIMPLE      | n2       | eq_ref | PRIMARY                             | PRIMARY | 4       | m.CUSTOMER.C_NATIONKEY | 1       | 1.00       |   100.00 |       8.20 | Using where                                  |
|    1 | SIMPLE      | n1       | eq_ref | PRIMARY                             | PRIMARY | 4       | m.SUPPLIER.S_NATIONKEY | 1       | 1.00       |   100.00 |       3.98 | Using where                                  |
+------+-------------+----------+--------+-------------------------------------+---------+---------+------------------------+---------+------------+----------+------------+----------------------------------------------+
6 rows in set (3.114 sec)

MariaDB [m]> notee