Missing index analysis and index useage statistics
US7769744B2 · kind B2 · utility
20Cited by
23References
16Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Dec 2, 2005 |
| Grant date | Aug 3, 2010 |
| Priority date | — |
| Expiry date | Jun 10, 2027 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/22
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method of accumulating and aggregating statistics concerning the use of database table indexes includes using a plurality of counters to register index use. The plurality of counters allow multiple instances of index usage to be recorded simultaneously. A missing index may be detected using an optimal index in a query plan. The optimal index is compared against the available indexes to determine if an index is missing. Statistics may be gathered against the used and missing indexes.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.