Method and mechanism for database statement optimization
US6351742B1 · kind B1 · utility
75Cited by
10References
34Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Mar 18, 1999 |
| Grant date | Feb 26, 2002 |
| Priority date | — |
| Expiry date | Mar 18, 2019 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99936
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method and system for optimizing the execution of database statements are described. An aspect is directed to the generation of an execution plan for a database statement, wherein the database statement contains a predicate having one or more arguments whose values are not known at the time the execution plan is generated (e.g., at compile time). A feature of this aspect involves passing a description of the argument(s) to the optimizer. An example of such a description includes the argument type of the predicate argument.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.