Pivotal Knowledge Base

Follow

How to Optimize Common Table Expression (CTE) i.e WITH clause statement in Greenplum?

Environment

Pivotal Greenplum Database (GPDB) all versions

Introduction

This article describes how to use the common table expression (CTE) i.e "With" clause effectively on GPDB and how does the planner make the plan for CTE queries.

Description

Here is a quick video explaining on how the optimizer uses its intelligence to build a plan for CTE related queries and also on how to use the "With" clause statement effectively with GPDB.

Comments

Powered by Zendesk