[TRAFODION-2315] Heuristic decision on when to use a temp table for WITH clause

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: sql-cmp
• Assignee: Hans Zeller
• Reporter: Hans Zeller
• Created: 26/Oct/16 22:51
• Updated: 30/Jan/17 19:34
• Resolved: 30/Jan/17 19:33

Description

This is a follow-up to TRAFODION-2127.

The code delivered for TRAFODION-2127 puts in the infrastructure to create a temp table, but it does not provide heuristics to decide automatically when to do this transformation. CQD CSE_USE_TEMP can only be used to force the transformation ON or OFF.

Issue Links

• links to: GitHub Pull Request #928