Minimizing processing using an index when non-leading columns match an aggregation key
US11010380B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Feb 13, 2018 |
| Grant date | May 18, 2021 |
| Priority date | — |
| Expiry date | Feb 22, 2039 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/248
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Provided are techniques for minimizing processing using an index when non-leading columns match an aggregation key. A query that includes a clause and an aggregation key is received. It is determined that a non-leading key column of an index matches a column of the aggregation key comprising any of: a leading column of an ORDER BY aggregation key, any column of a duplicate removal aggregation key, a MIN aggregation key, and a MAX aggregation key. The clause is processed using an order of the aggregation key to generate a first result set. Then, the clause is processed using the non-leading key column of the index that matched the column of the aggregation key and the first result set to generate a second result set. The second result set is returned.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.