MariaDB [demo]> source Q8-analyze.sql;
+------+-------------+----------+--------+--------------------------------------------------------------+---------+---------+---------------------------+---------+------------+----------+------------+-------------------------------------------------+
| id   | select_type | table    | type   | possible_keys                                                | key     | key_len | ref                       | rows    | r_rows     | filtered | r_filtered | Extra                                           |
+------+-------------+----------+--------+--------------------------------------------------------------+---------+---------+---------------------------+---------+------------+----------+------------+-------------------------------------------------+
|    1 | SIMPLE      | ORDERS   | ALL    | PRIMARY,ORDERS_FK1                                           | NULL    | NULL    | NULL                      | 1487077 | 1500000.00 |   100.00 |      30.41 | Using where; Using temporary; Using filesort    |
|    1 | SIMPLE      | CUSTOMER | eq_ref | PRIMARY,CUSTOMER_NATION_FKIDX                                | PRIMARY | 4       | demo.ORDERS.O_CUSTKEY     | 1       | 1.00       |   100.00 |     100.00 | Using where                                     |
|    1 | SIMPLE      | n1       | eq_ref | PRIMARY,NATION_REGIONKEY_FKIDX                               | PRIMARY | 4       | demo.CUSTOMER.C_NATIONKEY | 1       | 1.00       |   100.00 |     100.00 |                                                 |
|    1 | SIMPLE      | REGION   | ALL    | PRIMARY                                                      | NULL    | NULL    | NULL                      | 5       | 5.00       |    20.00 |       4.05 | Using where; Using join buffer (flat, BNL join) |
|    1 | SIMPLE      | LINEITEM | ref    | PRIMARY,LINEITEM_PART_SUPP_FKIDX,IDX_LINEITEM_ORDERKEY_FKIDX | PRIMARY | 8       | demo.ORDERS.O_ORDERKEY    | 4       | 4.00       |    75.00 |     100.00 |                                                 |
|    1 | SIMPLE      | PART     | eq_ref | PRIMARY                                                      | PRIMARY | 4       | demo.LINEITEM.L_PARTKEY   | 1       | 1.00       |   100.00 |       0.66 | Using where                                     |
|    1 | SIMPLE      | SUPPLIER | eq_ref | PRIMARY,SUPPLIER_NATION_FKIDX                                | PRIMARY | 4       | demo.LINEITEM.L_SUPPKEY   | 1       | 1.00       |   100.00 |     100.00 |                                                 |
|    1 | SIMPLE      | n2       | ALL    | PRIMARY                                                      | NULL    | NULL    | NULL                      | 25      | 25.00      |     4.00 |       4.00 | Using where; Using join buffer (flat, BNL join) |
+------+-------------+----------+--------+--------------------------------------------------------------+---------+---------+---------------------------+---------+------------+----------+------------+-------------------------------------------------+
8 rows in set (1.900 sec)

MariaDB [demo]> notee