Statistics adjustment to improve query execution plans
US7877374B2 · kind B2 · utility
24Cited by
8References
15Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Dec 1, 2006 |
| Grant date | Jan 25, 2011 |
| Priority date | — |
| Expiry date | May 30, 2027 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24545
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A query execution system is provided. The system includes a monitor component that detects data value changes in a database. An adjustment component initiates an intermediate query in view of detected data value changes, the intermediate query employed to adjust statistics related to a query plan optimization.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.