Optimizing a database query that returns a predetermined number of rows using a generated optimized access plan
US7343367B2 · kind B2 · utility
7Cited by
6References
4Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | May 12, 2005 |
| Grant date | Mar 11, 2008 |
| Priority date | — |
| Expiry date | Oct 28, 2025 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99937
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
An apparatus and method to optimize a query access plan in a computer database system. In preferred embodiments, the query optimizer determines the query can be optimized and generates for the query an optimized access plan that eliminates records defined by a Where clause and one or more ordering criteria prior to ordering the records (sorting or grouping) and then returning a first n rows.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.