INDEX MERGE ORDERING
First Claim
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; and
returning the first ordering column value as being responsive to the query.
1 Assignment
0 Petitions
Accused Products
Abstract
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.
14 Citations
7 Claims
-
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; and returning the first ordering column value as being responsive to the query. - View Dependent Claims (2, 3, 4, 5, 6, 7)
Specification