Invention Grant
US08126872B2 Methods of cost estimation using partially applied predicates 失效
使用部分应用谓词的成本估算方法

Methods of cost estimation using partially applied predicates
Abstract:
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.
Public/Granted literature
Information query
Patent Agency Ranking
0/0