Comment by riku_iki

clickbench is a toy benchmark: small dataset, very specific queries.

Benchmarking full tcp-h (not just one query like in your post) on sizable dataset (few TBs) would be very good close to real world scenario, but vendors usually avoid this.