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)