Joined table expression optimization by query transformation
US6385603B1 · kind B1 · utility
34Cited by
14References
15Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Jun 14, 1999 |
| Grant date | May 7, 2002 |
| Priority date | — |
| Expiry date | Jun 14, 2019 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99935
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A query optimizer analyzes a query and triggers a sequence of transformations to achieve optimal performance for joined table expressions. The transformations include pushing down predicates for joined table expressions and pushing down non-null predicates to simplify join operators for joined table expressions.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.