· Pivotal Engineering Journal

Sep 30, 2019
Merge Join Support In GPORCA We look at how FULL JOINS can be supported natively in GPORCA, allowing GPORCA to generate plans providing better query execution times. Categories: Databases Query Optimization SQL Greenplum GPORCA Full Join
Aug 9, 2018
GiST Support In GPORCA We look at how GIST indexes can be supported in GPORCA, allowing GPORCA to generate plans providing better query execution times. Categories: Databases Query Optimization SQL Greenplum GPORCA GiST
Oct 12, 2016
Profiling Query Compilation Time with GPORCA GPORCA is Pivotal’s Query Optimizer for Greenplum Database and Apache HAWQ (incubating). In this post, we describe how users can profile query compilation with GPORCA. This will aid users in understanding which of GPORCA’s steps is the most resource intensive, and what transformations are being triggered. Based on this information, users can provide query hints to reduce or increase the search space, see where the time and memory is being spent, and learn how to influence its decision making. Categories: Databases GPDB HAWQ PQO GPORCA Query Optimization SQL