Sciweavers

87 search results - page 3 / 18
» Configuration-parametric query optimization for physical des...
Sort
View
ICDE
2006
IEEE
169views Database» more  ICDE 2006»
15 years 3 days ago
Scalable Exploration of Physical Database Design
Physical database design is critical to the performance of a large-scale DBMS. The corresponding automated design tuning tools need to select the best physical design from a large...
Arnd Christian König, Shubha U. Nabar
VLDB
2004
ACM
169views Database» more  VLDB 2004»
14 years 4 months ago
Database Tuning Advisor for Microsoft SQL Server 2005
The Database Tuning Advisor (DTA) that is part of Microsoft SQL Server 2005 is an automated physical database design tool that significantly advances the state-of-the-art in sever...
Sanjay Agrawal, Surajit Chaudhuri, Lubor Koll&aacu...
SIGMOD
2003
ACM
146views Database» more  SIGMOD 2003»
14 years 11 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...
EDBT
2008
ACM
118views Database» more  EDBT 2008»
14 years 11 months ago
Robustness in automatic physical database design
Automatic physical database design tools rely on "what-if" interfaces to the query optimizer to estimate the execution time of the training query workload under differen...
Kareem El Gebaly, Ashraf Aboulnaga
PVLDB
2010
85views more  PVLDB 2010»
13 years 9 months ago
Xplus: A SQL-Tuning-Aware Query Optimizer
The need to improve a suboptimal execution plan picked by the query optimizer for a repeatedly run SQL query arises routinely. Complex expressions, skewed or correlated data, and ...
Herodotos Herodotou, Shivnath Babu