Tag: query‑planning
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...
Databases are Just Loops - Part 3: Row and Batch execution
Our database journey makes a brief stop. We need to appreciate an important design decision every database must make: Should I use row or batch execution? Depending on the database - or...
What is Cost in a Query Planner?
If you ever looked at query plan from a SQL databases - you are likely to have come into something called "cost". You may even have heard that most advanced database use based a...