Runtime statistics feedback for query plan cost estimation
US12353412B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Sep 25, 2023 |
| Grant date | Jul 8, 2025 |
| Priority date | — |
| Expiry date | Sep 28, 2043 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/284
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A computer implemented method can execute a first query plan for a query, obtain statistics for internal nodes of a first query tree representing the first query plan, receive a second query tree representing a second query plan for the query, search for a matching internal node of the first query tree for a selected internal node of the second query tree, and responsive to finding the matching internal node of the first query tree, apply the statistics for the matching internal node of the first query tree to the selected internal node of the second query tree for estimating cost of the second query plan during query optimization of the query. Related systems and software for implementing the method are also disclosed.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.