3 ms·
Did any of the actual benchmark queries in TPC-H or TPC-DS show a speed up? My intuition is that the performance of large sorts (100 millions of rows) are not
by AdamProut 5y ago
Did any of the actual benchmark queries in TPC-H or TPC-DS show a speed up?
My intuition is that the performance of large sorts (100 millions of rows) are not that important for most analytical workloads compared to the performance of doing scans, group-bys and joins. Top-sorts (ORDER BY X LIMIT N) are much more popular, but most databases use different algorithms for those.
- lnkuiper 5y agoThere are plenty of TopN sorts in TPC-DS, but not many (if any) regular sorts, so no. There are order-dependent window functions in there though, which did show a speed up.