发明名称 |
METHODS OF COST ESTIMATION USING PARTIALLY APPLIED PREDICATES |
摘要 |
In accordance with aspects of the present invention, provided are methods for incrementally estimating the cardinality of a derived relation including statistically correlated partially applicable predicates for a range-partitioned table. During the generation of a QEP a cardinality estimate is calculated in which one or more partially applicable predicates is correlated to another partially applicable predicate and/or to one or more fully applicable predicates. The cardinality includes a number of rows expected to be returned by the QEP and is computed in an incremental fashion for each operator of the QEP.
|
申请公布号 |
US2009055352(A1) |
申请公布日期 |
2009.02.26 |
申请号 |
US20080261075 |
申请日期 |
2008.10.30 |
申请人 |
INTERNATIONAL BUSINESS MACHINES CORPORATION |
发明人 |
CORVINELLI VINCENT;HORNIBROOK JOHN FREDERICK;MIAO BINGJIE |
分类号 |
G06F7/06;G06F17/30 |
主分类号 |
G06F7/06 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|