INDEX MERGE ORDERING
1 Assignment
0 Petitions
Accused Products
Abstract
System, method, and computer program product 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.
-
Citations
20 Claims
-
1-7. -7. (canceled)
-
8. A system, comprising:
-
a computer processor; and a memory containing a program, which when executed by the computer processor, performs an operation to order query results, the operation 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; and returning the first ordering column value as being responsive to the query. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
-
15. A computer program product, comprising:
computer code that, when executed by a processor, performs an operation 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; and returning the first ordering column value as being responsive to the query. - View Dependent Claims (16, 17, 18, 19, 20)
Specification