In MDEV-36861, analyze Q4

select o_orderpriority, count(*) as order_count

from ORDERS

where

  o_orderdate >= date '1993-06-01'

  and o_orderdate < date '1993-06-01' + interval '3' month

  and exists

  (

    select * from LINEITEM 

    where l_orderkey = o_orderkey and l_commitdate < l_receiptdate

  )

group by o_orderpriority

order by o_orderpriority;

query_id	id	select_type	table	type	possible_keys	key	key_len	ref	rows	r_rows	filtered	r_filtered	Extra

q4	1	PRIMARY	ORDERS	ALL	PRIMARY	NULL	NULL	NULL	1469276	1500000.00	100	3.82	Using where; Using temporary; Using filesort

q4	1	PRIMARY	LINEITEM	ref	PRIMARY,IDX_LINEITEM_ORDERKEY_FKIDX	PRIMARY	8	tpch.ORDERS.O_ORDERKEY	1	1.45	100	63.43	Using where; FirstMatch(ORDERS)

query_id	id	select_type	table	type	possible_keys	key	key_len	ref	rows	r_rows	filtered	r_filtered	Extra

q4	1	PRIMARY	ORDERS	ALL	PRIMARY	NULL	NULL	NULL	1465728	1500000.00	100	3.82	Using where; Using temporary; Using filesort

q4	1	PRIMARY	<subquery2>	eq_ref	distinct_key	distinct_key	8	func	1	0.92	100	100	

q4	2	MATERIALIZED	LINEITEM	ALL	PRIMARY,IDX_LINEITEM_ORDERKEY_FKIDX	NULL	NULL	NULL	5982557	5992551.00	100	63.22	Using where