Selective database statistics recollection
US7676451B2 · kind B2 · utility
2Cited by
6References
18Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | May 3, 2007 |
| Grant date | Mar 9, 2010 |
| Priority date | — |
| Expiry date | Feb 20, 2028 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2428
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
The subject mater herein relates to database management and, more particularly, to selective database statistics recollection. Various embodiments provide one or more of system, methods, and software that identify database column and index states when statistics become stale to a point where query execution plans against respective columns and indexes fail to be efficient. These and other embodiments provide a way to update column and index statistics only when the statistics are determined to be stale. As a result, adverse database performance as a result of needless updating of database statistics is mitigated.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.