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            | NATION   | ALL    | PRIMARY,NATION_REGIONKEY_FKIDX                      | NULL                    | NULL    | NULL                   | 25   | 25.00  |   100.00 |     100.00 | Using where; Using temporary; Using filesort |
|    1 | PRIMARY            | REGION   | eq_ref | PRIMARY                                             | PRIMARY                 | 4       | m.NATION.N_REGIONKEY   | 1    | 1.00   |   100.00 |      20.00 | Using where                                  |
|    1 | PRIMARY            | SUPPLIER | ref    | PRIMARY,SUPPLIER_NATION_FKIDX                       | SUPPLIER_NATION_FKIDX   | 5       | m.NATION.N_NATIONKEY   | 389  | 409.60 |   100.00 |     100.00 |                                              |
|    1 | PRIMARY            | PARTSUPP | ref    | PRIMARY,PARTSUPP_PART_FKIDX,PARTSUPP_SUPPLIER_FKIDX | PARTSUPP_SUPPLIER_FKIDX | 4       | m.SUPPLIER.S_SUPPKEY   | 80   | 80.00  |   100.00 |     100.00 |                                              |
|    1 | PRIMARY            | PART     | eq_ref | PRIMARY                                             | PRIMARY                 | 4       | m.PARTSUPP.PS_PARTKEY  | 1    | 1.00   |   100.00 |       0.29 | 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 |      40.38 | Using where                                  |
+------+--------------------+----------+--------+-----------------------------------------------------+-------------------------+---------+------------------------+------+--------+----------+------------+----------------------------------------------+
9 rows in set (0.478 sec)

MariaDB [m]> notee