MariaDB [tpch]> source Q2.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 | tpch.NATION.N_REGIONKEY | 1 | 1.00 | 100.00 | 20.00 | Using where | | 1 | PRIMARY | SUPPLIER | ref | PRIMARY,SUPPLIER_NATION_FKIDX | SUPPLIER_NATION_FKIDX | 5 | tpch.NATION.N_NATIONKEY | 400 | 409.60 | 100.00 | 100.00 | | | 1 | PRIMARY | PARTSUPP | ref | PRIMARY,PARTSUPP_PART_FKIDX,PARTSUPP_SUPPLIER_FKIDX | PARTSUPP_SUPPLIER_FKIDX | 4 | tpch.SUPPLIER.S_SUPPKEY | 79 | 80.00 | 100.00 | 100.00 | | | 1 | PRIMARY | PART | eq_ref | PRIMARY | PRIMARY | 4 | tpch.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 | tpch.PART.P_PARTKEY | 3 | 4.00 | 100.00 | 100.00 | | | 2 | DEPENDENT SUBQUERY | SUPPLIER | eq_ref | PRIMARY,SUPPLIER_NATION_FKIDX | PRIMARY | 4 | tpch.PARTSUPP.PS_SUPPKEY | 1 | 1.00 | 100.00 | 100.00 | Using where | | 2 | DEPENDENT SUBQUERY | NATION | eq_ref | PRIMARY,NATION_REGIONKEY_FKIDX | PRIMARY | 4 | tpch.SUPPLIER.S_NATIONKEY | 1 | 1.00 | 100.00 | 100.00 | Using where | | 2 | DEPENDENT SUBQUERY | REGION | eq_ref | PRIMARY | PRIMARY | 4 | tpch.NATION.N_REGIONKEY | 1 | 1.00 | 100.00 | 40.38 | Using where | +------+--------------------+----------+--------+-----------------------------------------------------+-------------------------+---------+---------------------------+------+--------+----------+------------+----------------------------------------------+ 9 rows in set (0.561 sec) MariaDB [tpch]> notee