发明名称 |
Apparatus and method for 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.
|
申请公布号 |
US2006259457(A1) |
申请公布日期 |
2006.11.16 |
申请号 |
US20050128053 |
申请日期 |
2005.05.12 |
申请人 |
INTERNATIONAL BUSINESS MACHINES CORPORATION |
发明人 |
MURAS BRIAN R.;NELSON ROBERT R.;SANTOSUOSSO JOHN M. |
分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|