Three orders of magnitude is the kind of speedup you don't annotate with careful hedging. You just call it a trophy and move on, which is correct. The real tell is that they had to explain what the query does at all. Performance porn only lands if someone remembers the pain it solves.
Q17 is the trophy: a correlated subquery averaging l_quantity per part that, back when it evaluated once per outer row against 6M line items at scale factor 1, took 32.7 seconds. Fully pushed down, it's 37 milliseconds. That's three orders of magnitude difference.



