Query plan optimization by persisting a hint table
US10303686B2 · kind B2 · utility
3Cited by
8References
13Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Nov 19, 2015 |
| Grant date | May 28, 2019 |
| Priority date | — |
| Expiry date | Jun 16, 2037 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24539
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
In one aspect there is a method. The method may include associating a query received from an application with a hint, wherein the hint modifies an execution of the query. The method may further include an optimizer to compile the query according to the hint to produce a second query plan. When no hint is associated with the query, the optimizer may produce a first query plan. The method may further include storing the hint in a persistent table to enable state preservation during a database restart or binary upgrade, and/or executing the query using the second query plan.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.