88 search results - page 1 / 18 » Exploiting statistics on query expressions for optimization |
SIGMOD
2002
ACM
14 years 5 months ago
2002
ACM
Statistics play an important role in influencing the plans produced by a query optimizer. Traditionally, optimizers use statistics built over base tables and assume independence b...
SIGMOD
2004
ACM
14 years 5 months ago
2004
ACM
Cardinality estimation during query optimization relies on simplifying assumptions that usually do not hold in practice. To diminish the impact of inaccurate estimates during opti...
ICDE
2003
IEEE
14 years 6 months ago
2003
IEEE
Query optimizers use base-table statistics to derive statistics on the sub-plans that are enumerated during optimization. In practice, traditional optimizers rely on a number of s...
SIGMOD
2003
ACM
14 years 5 months ago
2003
ACM
Decision-support applications generate queries with complex predicates. We show how the factorization of complex query expressions exposes significant opportunities for exploiting...
CIKM
2008
Springer
13 years 6 months ago
2008
Springer
The typical workload in a database system consists of a mixture of multiple queries of different types, running concurrently and interacting with each other. Hence, optimizing per...