Synthesized predicate driven index selection for partitioned table
US10387404B1 · kind B1 · utility
1Cited by
2References
20Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Nov 30, 2016 |
| Grant date | Aug 20, 2019 |
| Priority date | — |
| Expiry date | Oct 21, 2037 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24554
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A system and method for receiving a query of a partitioned table, the query including a first index predicate associated with a first partition key column; determining that one or more of the query is missing a second index predicate and the first index predicate is unusable for index probing; responsive to determining that one or more of the query is missing the second index predicate and the first index predicate is unusable for index probing, generating one or more synthesized predicates used to process the query using an index scan.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.