Invention Grant
- Patent Title: Reduced fixed length sort of variable length columns
-
Application No.: US15476534Application Date: 2017-03-31
-
Publication No.: US10671587B2Publication Date: 2020-06-02
- Inventor: Brian L. Baggett , Allan B. Lebovitz , Terence P. Purcell
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Konrad, Raynes, Davda and Victor LLP
- Agent Janaki K. Davda
- Main IPC: G06F16/22
- IPC: G06F16/22 ; G06F16/2455

Abstract:
Provided are techniques for reduced fixed length sort of variable length columns. A fixed length sort is performed to sort a table having rows for a query, wherein the fixed length sort is based on a sort key comprised of a variable length column. A pre-determined number of the rows are read to identify the variable length column as a candidate for truncation. A length for truncating the variable length column is determined based on database statistics and based on the reading of the pre-determined number of the rows. The variable length column is truncated to the determined length to output a truncated variable length column for the sort key. The rows are sorted on the sort key having the truncated variable length column. Results are generated using the sorted rows and returned for the query.
Public/Granted literature
- US20180285428A1 REDUCED FIXED LENGTH SORT OF VARIABLE LENGTH COLUMNS Public/Granted day:2018-10-04
Information query