3 ms·
There are several existing benchmarks that test query optimisers with a lot of joins. It does not show performance of query engine, but more likely how good is
by qoega 4y ago
There are several existing benchmarks that test query optimisers with a lot of joins. It does not show performance of query engine, but more likely how good is your optimiser was tailored for this queries.
- AdamProut 4y agoI think your missing my point. The page is entitled "a Benchmark For Analytical DBMS" not "A Benchmark for Single Table Query Execution". Most analytical workloads are more complex then single table queries. I didn't say it wasn't useful to test single table columnstore performance on workload that runs best on single host databases, just that this isn't the be-all end-all of Analytical Database performance testing.
- zX41ZdbW 4y agoYou are absolutely right. That's why this benchmark is named "a Benchmark For Analytical DBMS", not "the definitive benchmark for analytical DBMS".
- ruw1090 4y agoThere's a lot more involved in an execution engine running complex queries that are not single table group by than just QO (though this is important). It includes things like join implementations and associated optimizations, shuffle performance (which is important even for single table queries as you scale), etc.
- riku_iki 4y ago> It does not show performance of query engine, but more likely how good is your optimiser was tailored for this queries. you can join just two large tables without leaving much space for query optimizer.