The Database Doctor
Musing about Databases

Tag: ee

Cover image for TPC series - TPC-H Query 8 - Loops, merges and hash
TPC series - TPC-H Query 8 - Loops, merges and hash

In today's look at TPCH-H Q08, we're going to once again walk through an optimal join order example. The query is quite boring, but it does allow me to talk about a few other things related...

Cover image for Databases are Just Loops - Row and Batch execution
Databases are Just Loops - 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...