Here is TPCH 4 with sf 100:
count(*) as order_count
o.o_orderdate >= date '1996-10-01'
and o.o_orderdate < date '1996-10-01' + interval '3' month
l.l_orderkey = o.o_orderkey
and l.l_commitdate < l.l_receiptdate
The plan has changed when Statistics is disabled. A Hash Agg and a Broadcast Exchange have been added. These two operators expand the number of rows from the lineitem table from 137M to 9B rows. This forces the hash join to use 6GB of memory instead of 30 MB.