MariaDB [tpch]> source Q9.sql
+------+-------------+----------+--------+--------------------------------------------------------------+--------------------------+---------+---------------------------------------------+--------+-----------+----------+------------+----------------------------------------------+
| id   | select_type | table    | type   | possible_keys                                                | key                      | key_len | ref                                         | rows   | r_rows    | filtered | r_filtered | Extra                                        |
+------+-------------+----------+--------+--------------------------------------------------------------+--------------------------+---------+---------------------------------------------+--------+-----------+----------+------------+----------------------------------------------+
|    1 | SIMPLE      | PART     | ALL    | PRIMARY                                                      | NULL                     | NULL    | NULL                                        | 197777 | 200000.00 |     4.00 |       5.32 | Using where; Using temporary; Using filesort |
|    1 | SIMPLE      | LINEITEM | ref    | PRIMARY,LINEITEM_PART_SUPP_FKIDX,IDX_LINEITEM_ORDERKEY_FKIDX | LINEITEM_PART_SUPP_FKIDX | 4       | tpch.PART.P_PARTKEY                         | 31     | 29.98     |   100.00 |     100.00 |                                              |
|    1 | SIMPLE      | SUPPLIER | eq_ref | PRIMARY,SUPPLIER_NATION_FKIDX                                | PRIMARY                  | 4       | tpch.LINEITEM.L_SUPPKEY                     | 1      | 1.00      |   100.00 |     100.00 | Using where                                  |
|    1 | SIMPLE      | PARTSUPP | eq_ref | PRIMARY,PARTSUPP_PART_FKIDX,PARTSUPP_SUPPLIER_FKIDX          | PRIMARY                  | 8       | tpch.PART.P_PARTKEY,tpch.LINEITEM.L_SUPPKEY | 1      | 1.00      |   100.00 |     100.00 |                                              |
|    1 | SIMPLE      | ORDERS   | eq_ref | PRIMARY                                                      | PRIMARY                  | 8       | tpch.LINEITEM.L_ORDERKEY                    | 1      | 1.00      |   100.00 |     100.00 |                                              |
|    1 | SIMPLE      | NATION   | eq_ref | PRIMARY                                                      | PRIMARY                  | 4       | tpch.SUPPLIER.S_NATIONKEY                   | 1      | 1.00      |   100.00 |     100.00 |                                              |
+------+-------------+----------+--------+--------------------------------------------------------------+--------------------------+---------+---------------------------------------------+--------+-----------+----------+------------+----------------------------------------------+
6 rows in set (1.878 sec)

MariaDB [tpch]> notee