Synthesized predicate driven index selection for partitioned table
US10990583B1 · kind B1 · utility
3Cited by
2References
20Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Aug 2, 2019 |
| Grant date | Apr 27, 2021 |
| Priority date | — |
| Expiry date | Aug 21, 2039 |
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.