Faster Optimization of Join Queries in ORCA

January 15, 2021 HansZeller

author:Hans Zeller Optimizing joins is the core part of any query optimizer. It consists of picking a good join order, the right join algorithms (hash join, nested loop join, etc.) and various other things. The number of possible options grows extremely fast and requires a method called Dynamic Programming to keep the search effort for …

Faster Optimization of Join Queries in ORCA Read More »

Previous
Relationship and difference between Greenplum and PostgreSQL
Relationship and difference between Greenplum and PostgreSQL

Greenplum is open-source software for massively parallel database used for reporting, analytics, machine le...

Next
Data Science with Python & JupyterHub on Kubernetes - Part 2
Data Science with Python & JupyterHub on Kubernetes - Part 2

In a previous post, we discussed the advantages of running JupyterHub on Kubernetes. We also showed you how...