Query Plan Optimization: Join Predicate Ordering
Query Plan Optimization: Join Predicate Ordering
After the improvement of Hyrise’s execution engine that was presented in our last article, this post will again deal with a query plan…
Parallelization efforts using VTune
Parallelization efforts using VTune
Up to this point, we focused a lot on query plan optimization based on individual long-running queries (Sub-Plan Memoization, Disjunction…
Query Plan Optimization: Disjunction Split-Up
Query Plan Optimization: Disjunction Split-Up
In our previous blog post, we showed how optimizations of the Logical Query Plan (LQP) could improve the performance of Hyrise in the…
Reducing Hyrise’s build time
Reducing Hyrise’s build time
Over time, we have identified a number of factors that directly influence our developers’ productivity. These cover areas such as code…
Query Plan Optimization: Sub-Plan Memoization
Query Plan Optimization: Sub-Plan Memoization
In the previous blog posts, we introduced the Hyrise master’s project of the summer semester 2019 and gave an overview of the TPC-DS…
Query Optimization w/ TPC-DS
Query Optimization w/ TPC-DS
Introduction to the Hyrise master’s project — summer term 2019
Having a closer look under the hood
Having a closer look under the hood
Instrumenting code on demand via USDT
Taming SQL for Query Optimization
Taming SQL for Query Optimization
How we added a Query Optimizer to Hyrise
A Matter of Self-Expression
A Matter of Self-Expression
Making Sense of SQL Expressions for Query Optimization
