The Database Doctor
Musing about Databases

Tag: row

Cover image for TPC series - TPC-H Query 6 - Expression Optimisation
TPC series - TPC-H Query 6 - Expression Optimisation

Reading Time: 5 min, Date: 10/13/2025

And now, for something completely different. This week on TPC-H query analysis - we are not going to look at join ordering. Today's query does not have any joins. But as we shall see, is to...

Cover image for Row or Column based Storage?
Row or Column based Storage?

Reading Time: 4 min, Date: 4/7/2023

These days, columnar storage formats are getting a lot more attention in relational databases. Parquet, with its superior compression, is quickly taking over from CSV formats. SAP a...