Tracking table and index partition usage in a database
US8051055B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Aug 7, 2008 |
| Grant date | Nov 1, 2011 |
| Priority date | — |
| Expiry date | Jan 4, 2030 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/217
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Apparatus, methods and computer-readable medium for displaying information related to performance of a given database statement which accesses a plurality of multi-partition objects during a time interval. In some embodiments, the method comprises: a) determining, for a given database statement that accesses a plurality of index or table partitions during the time interval, for each accessed partition of a plurality of partitions, a respective aggregate wait time associated with said accessed partition; b) in accordance with the determined wait times for the given database statement, presenting, to a user, a description of performance of the database during the time interval.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.