Method and system for performing query optimization using a hybrid execution plan
US8903805B2 · kind B2 · utility
4Cited by
31References
43Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Aug 20, 2010 |
| Grant date | Dec 2, 2014 |
| Priority date | — |
| Expiry date | Jan 13, 2031 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24545
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
An improved method, system, and computer program product is disclosed that provides a hybrid approach to optimization which allows different subsets of data accessed by a query to be optimized with different access paths and execution approaches. Transformations may be performed to re-write the query, which restructures the query in a way that facilitates the hybrid optimization process. Multiple transformations may be interleaved to produce an efficient re-written query.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.