MariaDB [m]> source Q2-analyze.sql;
+------+--------------------+----------+--------+-----------------------------------------------------+---------+---------+------------------------+--------+-----------+----------+------------+----------------------------------------------+
| id   | select_type        | table    | type   | possible_keys                                       | key     | key_len | ref                    | rows   | r_rows    | filtered | r_filtered | Extra                                        |
+------+--------------------+----------+--------+-----------------------------------------------------+---------+---------+------------------------+--------+-----------+----------+------------+----------------------------------------------+
|    1 | PRIMARY            | PART     | ALL    | PRIMARY                                             | NULL    | NULL    | NULL                   | 198268 | 200000.00 |    19.00 |       0.39 | Using where; Using temporary; Using filesort |
|    1 | PRIMARY            | PARTSUPP | ref    | PRIMARY,PARTSUPP_PART_FKIDX,PARTSUPP_SUPPLIER_FKIDX | PRIMARY | 4       | m.PART.P_PARTKEY       | 4      | 4.00      |    75.00 |      15.20 | Using where                                  |
|    1 | PRIMARY            | SUPPLIER | eq_ref | PRIMARY,SUPPLIER_NATION_FKIDX                       | PRIMARY | 4       | m.PARTSUPP.PS_SUPPKEY  | 1      | 1.00      |   100.00 |     100.00 | Using where                                  |
|    1 | PRIMARY            | NATION   | eq_ref | PRIMARY,NATION_REGIONKEY_FKIDX                      | PRIMARY | 4       | m.SUPPLIER.S_NATIONKEY | 1      | 1.00      |   100.00 |     100.00 | Using where                                  |
|    1 | PRIMARY            | REGION   | eq_ref | PRIMARY                                             | PRIMARY | 4       | m.NATION.N_REGIONKEY   | 1      | 1.00      |   100.00 |      99.79 | Using where                                  |
|    2 | DEPENDENT SUBQUERY | PARTSUPP | ref    | PRIMARY,PARTSUPP_PART_FKIDX,PARTSUPP_SUPPLIER_FKIDX | PRIMARY | 4       | m.PART.P_PARTKEY       | 4      | 4.00      |    75.00 |     100.00 |                                              |
|    2 | DEPENDENT SUBQUERY | SUPPLIER | eq_ref | PRIMARY,SUPPLIER_NATION_FKIDX                       | PRIMARY | 4       | m.PARTSUPP.PS_SUPPKEY  | 1      | 1.00      |   100.00 |     100.00 | Using where                                  |
|    2 | DEPENDENT SUBQUERY | NATION   | eq_ref | PRIMARY,NATION_REGIONKEY_FKIDX                      | PRIMARY | 4       | m.SUPPLIER.S_NATIONKEY | 1      | 1.00      |   100.00 |     100.00 | Using where                                  |
|    2 | DEPENDENT SUBQUERY | REGION   | eq_ref | PRIMARY                                             | PRIMARY | 4       | m.NATION.N_REGIONKEY   | 1      | 1.00      |   100.00 |      21.02 | Using where                                  |
+------+--------------------+----------+--------+-----------------------------------------------------+---------+---------+------------------------+--------+-----------+----------+------------+----------------------------------------------+
9 rows in set (0.059 sec)

MariaDB [m]> notee