System and method for optimizing queries
US10528553B2 · kind B2 · utility
0Cited by
21References
21Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Dec 19, 2014 |
| Grant date | Jan 7, 2020 |
| Priority date | — |
| Expiry date | Apr 6, 2037 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2455
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
There is provided a computer-implemented method of optimizing a query. An exemplary method retrieves a subset of rows from a sample table based on a query for a table associated with the sample table. The query specifies the table. The sample table is generated in a previous optimization of the query. The sample table includes a scrambled, random selection of rows from the table. A cardinality of the table is determined based on the subset. A query plan is generated based on the query and the cardinality.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.