Optimizing a computer database query that fetches N rows
US7756861B2 · kind B2 · utility
1Cited by
12References
13Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Sep 29, 2007 |
| Grant date | Jul 13, 2010 |
| Priority date | — |
| Expiry date | Sep 29, 2028 |
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.