Tag: query‑optimisation
TPC-H series - TPC-H Query 3 - Join Ordering and Heap Sorting
I want to teach you an important skill that will serve your well as a database specialist. One blog entry is not going to be enough, but here is my goal: When you look at an SQL query in the you...
Join Elimination in Query Planners
Most relational databases are both by human SQL query writers and tools that automatically generate queries. Query tools frequently add joins into the queries, even when those joins...