Logo image
Estimating the Output Cardinality of Partial Preaggregation with a Measure of Clusteredness
Conference proceeding   Peer reviewed

Estimating the Output Cardinality of Partial Preaggregation with a Measure of Clusteredness

Sven Helmer, Thomas Neumann and Guido Moerkotte
Proceedings of 29th International Conference on Very Large Data Bases, pp.656-667
VLDB 2003 - 29th International Conference on Very Large Data Bases (Berlin, 09/09/2003 - 12/09/2003)
2003
Handle:
https://hdl.handle.net/10863/1092

Abstract

We introduce a new parameter, the clusteredness of data, and show how it can be used for estimating the output cardinality of a partial preaggregation operator. This provides the query optimizer with an important piece of information for deciding whether the application of partial preaggregation is beneficial. Experimental results are very promising, due to the high accuracy of the cardinality estimation based on our measure of clusteredness.
url
http://dl.acm.org/citation.cfm?id=1315508&CFID=526183476&CFTOKEN=31077999View

Details

Metrics

31 Record Views