Sciweavers

3 search results - page 1 / 1
» Counting, Enumerating, and Sampling of Execution Plans in a ...
Sort
View
SIGMOD
2000
ACM
141views Database» more  SIGMOD 2000»
13 years 8 months ago
Counting, Enumerating, and Sampling of Execution Plans in a Cost-Based Query Optimizer
Testing an SQL database system by running large sets of deterministic or stochastic SQL statements is common practice in commercial database development. However, code defects oft...
Florian Waas, César A. Galindo-Legaria
SIGMOD
2003
ACM
146views Database» more  SIGMOD 2003»
14 years 4 months ago
Estimating Compilation Time of a Query Optimizer
A query optimizer compares alternative plans in its search space to find the best plan for a given query. Depending on the search space and the enumeration algorithm, optimizers v...
Ihab F. Ilyas, Jun Rao, Guy M. Lohman, Dengfeng Ga...
PVLDB
2008
100views more  PVLDB 2008»
13 years 3 months ago
Efficiently approximating query optimizer plan diagrams
Given a parametrized n-dimensional SQL query template and a choice of query optimizer, a plan diagram is a color-coded pictorial enumeration of the execution plan choices of the o...
Atreyee Dey, Sourjya Bhaumik, Harish D., Jayant R....