Pivotal Knowledge Base

Follow

How to optimize common table expression ( CTE ) i.e WITH clause statement in GPDB ?

Goal

  • How to use the common table expression ( CTE ) i.e WITH clause effectively on GPDB ? 
  • How does the planner make the plan for CTE queries ?

Solution

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

Comments

Powered by Zendesk