Query plan selection control using run-time association mechanism
US7640230B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Apr 5, 2005 |
| Grant date | Dec 29, 2009 |
| Priority date | — |
| Expiry date | Feb 22, 2026 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99934
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A system and method for creation, modification and/or use of plan guide(s) is provided. Plan guide(s) can be employed to optimize the performance of query(ies) when it is not possible and/or desirable to change the text of the query directly. Plan guides can be useful, for example, when a small subset of queries in a database application deployed from a third-party vendor is not performing as expected. Plan guides influence optimization of queries by attaching query hints to them. In accordance with an aspect of the subject invention, a query plan execution system is provided. The system includes an execution component, a query optimizer, and, a plan cache. Plan guides and other associated metadata are stored in a plan guide metadata store.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.