Prashanth Vasudev created TRAFODION-2259:
--------------------------------------------
Summary: Sort TopN operator
Key: TRAFODION-2259
URL: https://issues.apache.org/jira/browse/TRAFODION-2259
Project: Apache Trafodion
Issue Type: Improvement
Components: sql-exe
Affects Versions: 2.1-incubating
Reporter: Prashanth Vasudev
Assignee: Prashanth Vasudev
Sort operator consumes all records before producing sorted records. For certain
use cases where only Top N records are required, today sort consumes all
records into memory and overflows( spills ) to disk. This impacts performance.
if topN is pushed down to sort, only required memory can be allocated and sort
would only hold topN records in memory. Once all the records are read, sorted
records in topN is returned.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
