Tag: aggregate
TPC series - TPC-H Query 10 - Histograms and Functional Dependency
Welcome back to the TPC-H series, dear reader. And happy holidays to those of you who've already shut down. In today's educational blog, I'm going to teach you about: This is a lot of to in...
TPC series - TPC-H Query 9 - Composite Key Joins and Pre-aggregation
Today's query will give us a new insight about about query optimisers — because one of the joins contains a little extra surprise: Composite key joins. We will also learn about a new, we a...
Introducing the TPC series - TPC-H Query 1: Column Storage and Local Aggregation
After the wonderful feedback on the previous blog about Iceberg - it is now time to switch gears. Databases are more than row storage engines. They are algorithm machines, helping that...