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      | ORDERS   | ALL    | PRIMARY                                                      | NULL    | NULL    | NULL                                            | 1493904 | 1500000.00 |   100.00 |     100.00 | Using temporary; Using filesort |
|    1 | SIMPLE      | LINEITEM | ref    | PRIMARY,LINEITEM_PART_SUPP_FKIDX,IDX_LINEITEM_ORDERKEY_FKIDX | PRIMARY | 8       | tpch.ORDERS.O_ORDERKEY                          | 3       | 4.00       |   100.00 |     100.00 |                                 |
|    1 | SIMPLE      | PART     | eq_ref | PRIMARY                                                      | PRIMARY | 4       | tpch.LINEITEM.L_PARTKEY                         | 1       | 1.00       |   100.00 |       5.31 | Using where                     |
|    1 | SIMPLE      | PARTSUPP | eq_ref | PRIMARY,PARTSUPP_PART_FKIDX,PARTSUPP_SUPPLIER_FKIDX          | PRIMARY | 8       | tpch.LINEITEM.L_PARTKEY,tpch.LINEITEM.L_SUPPKEY | 1       | 1.00       |   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      | NATION   | eq_ref | PRIMARY                                                      | PRIMARY | 4       | tpch.SUPPLIER.S_NATIONKEY                       | 1       | 1.00       |   100.00 |     100.00 |                                 |
+------+-------------+----------+--------+--------------------------------------------------------------+---------+---------+-------------------------------------------------+---------+------------+----------+------------+---------------------------------+
6 rows in set (10.422 sec)

MariaDB [tpch]> notee