发明名称 |
INDEX MERGE ORDERING |
摘要 |
Method to order query results, by processing a received query at least in part using a composite key index, wherein the composite key index comprises at least two key columns, wherein the at least two key columns comprise at least one pre-ordering column and an ordering column, wherein the query specifies ordering criteria to order a result set based on values of the ordering column, wherein the processing comprises receiving, from the composite key index, an ordering column value for each unique pre-ordering column value in the composite key index, identifying a first ordering column value as being ordered first according to the ordering criteria, and returning the first ordering column value as being responsive to the query. |
申请公布号 |
US2015363470(A1) |
申请公布日期 |
2015.12.17 |
申请号 |
US201414505275 |
申请日期 |
2014.10.02 |
申请人 |
International Business Machines Corporation |
发明人 |
BESTGEN Robert J.;CAIN Michael W.;MCKINLEY Thomas O. |
分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
1. A method to order query results, comprising:
processing a received query at least in part using a composite key index, wherein the composite key index comprises at least two key columns, wherein the at least two key columns comprise at least one pre-ordering column and an ordering column, wherein the query specifies ordering criteria to order a result set based on values of the ordering column, by:
receiving, from the composite key index, an ordering column value for each unique pre-ordering column value in the composite key index;identifying a first ordering column value as being ordered first according to the ordering criteria; andreturning the first ordering column value as being responsive to the query. |
地址 |
Armonk NY US |