Re:What I Talk About When I Talk About Query Optimizer (Part...
by Sesse__ on Monday January 29, 2024 @05:39PM
(#39183758)
After a quick look, I'm not sure if I would call this “industrial strength”. In particular, the join optimizer (typically the heart of a large-scale SQL optimizer) looks very rudimentary? And the statistics it uses have zero idea about correlation, no histograms beyond min/max…
[ Parent
| on HN ]
Re:What I Talk About When I Talk About Query Optimizer (Part...
by menaerus on Tuesday January 30, 2024 @03:20AM
(#39187603)
I was wondering about the same claim. However, I believe that JOIN's are a common weakness among OLAP database engines, and DataFusion is built on top of a columnar storage format - Apache Arrow.