Description
The union up queue size is hardcoded in nadefaults.cpp as a start value as 16 which
is very low if large number of rows are being returned. Scan operator has it set to 2048.
Some operators further adjust this up size from the original value based on estimate of
the number of rows being returned. We can do that for union codegen method and
also change the original up queue size to 2048.
Noticed that Transpose, Sequence also have the same issue and dynamic queue resizing is missing.
Attachments
Issue Links
- is duplicated by
-
TRAFODION-2136 union all can't work efficiently
-
- Closed
-
- links to
