Maintain optimal query performance by presenting differences between access plans
US8161038B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Oct 29, 2004 |
| Grant date | Apr 17, 2012 |
| Priority date | — |
| Expiry date | Jan 9, 2030 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24542
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method, apparatus, system, and signal-bearing medium that, in an embodiment, collect previous and current statistics based on previous and current access plans, respectively, and a query. The previous and current statistics are compared in response to an event, and the differences between the previous and current statistics are presented. In various embodiments, the event may be a change to logic in a database management system that performs the query, a degradation in performance of the query, or a user request. In various embodiments, the difference may be a change to the previous access plan that causes performance degradation of the query, such as missing an index. The previous access plan is copied into the current access plan if an estimated processing time for the current access plan is greater than an estimated processing time for the previous access plan. The current access plan is used to perform the query.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.