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:
- The importance of histograms
- When not to do bushy joins
- Functional dependencies and how they speed up queries
- Bloom filters
This is a lot of ground to cover in the around 5-15 minutes I have your attention. Every deep dive starts at the surface — let us jump into the deep sea.