发明名称 |
Optimizing a computer database query that fetches n rows |
摘要 |
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.
|
申请公布号 |
US7567952(B2) |
申请公布日期 |
2009.07.28 |
申请号 |
US20070941772 |
申请日期 |
2007.11.16 |
申请人 |
INTERNATIONAL BUSINESS MACHINES CORPORATION |
发明人 |
MURAS BRIAN ROBERT;NELSON ROBERT RUSSELL;SANTOSUOSSO JOHN MATTHEW |
分类号 |
G06F7/00;G06F17/30 |
主分类号 |
G06F7/00 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|