DERBY-6921 How good is the Derby Query Optimizer, really

Query Optimization is an active field of research in the Database Research Community, researchers have spent significant time and resources studying the state of art in query optimization and continuously improving it through different approaches. At the 2015 VLDB conference, a team led by Dr. Viktor Leis at Munich Technical University introduced a new benchmark suite for evaluating database query optimizers. The research revisited the main components in the classic query optimizer architecture using a complex, real-world data set and realistic multi-join queries.

This project aims to obtain the above benchmark suite, obtains an end to end analysis of various components of Derby Query Optimizer, isolate each component’s contribution towards Derby query optimization and improve the components. The analysis obtained will serve as the knowledge base for Derby’s current state of art in query optimization and help in directing future efforts towards improving Derby in the long term.