Automatic query execution plan management and performance stabilization for workloads
US8805852B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Mar 2, 2009 |
| Grant date | Aug 12, 2014 |
| Priority date | — |
| Expiry date | Feb 14, 2032 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/217
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method, apparatus, and computer program product are disclosed for managing query execution plans for a workload. In one embodiment, the method includes gathering an initial set of performance characteristics generated from a database management system (DBMS) executing a database workload according to one or more query execution plans (QEPs). The database workload includes one or more database statements. The method determines a QEP change for one or more QEPs of the database workload. In addition, the method gathers a subsequent set of performance characteristics generated from the DBMS executing the one or more QEPs of the database workload influenced by the QEP change. Furthermore, the method determines a performance difference created by the QEP change based on the initial set of performance characteristics and the subsequent set of performance characteristics and responds to the performance difference in accordance with a monitoring policy.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.