Sciweavers

363 search results - page 3 / 73
» Analyzing Plan Diagrams of Database Query Optimizers
Sort
View
PODS
2004
ACM
100views Database» more  PODS 2004»
14 years 5 months ago
Weighted Hypertree Decompositions and Optimal Query Plans
Francesco Scarcello, Gianluigi Greco, Nicola Leone
SIGMOD
2003
ACM
136views Database» more  SIGMOD 2003»
14 years 5 months ago
A Characterization of the Sensitivity of Query Optimization to Storage Access Cost Parameters
Most relational query optimizers make use of information about the costs of accessing tuples and data structures on various storage devices. This information can at times be off b...
Frederick Reiss, Tapas Kanungo
DEBU
2008
141views more  DEBU 2008»
13 years 5 months ago
Oracle's SQL Performance Analyzer
We present the SQL Performance Analyzer, a novel approach in Oracle Database 11g to testing database changes, such as upgrades, parameter changes, schema changes, and gathering op...
Khaled Yagoub, Peter Belknap, Benoît Dagevil...
VLDB
2004
ACM
118views Database» more  VLDB 2004»
13 years 10 months ago
Green Query Optimization: Taming Query Optimization Overheads through Plan Recycling
PLASTIC [1] is a recently-proposed tool to help query optimizers significantly amortize optimization overheads through a technique of plan recycling. The tool groups similar quer...
Parag Sarda, Jayant R. Haritsa
VLDB
2002
ACM
126views Database» more  VLDB 2002»
13 years 5 months ago
Plan Selection Based on Query Clustering
Query optimization is a computationally intensive process, especially for complex queries. We present here a tool, called PLASTIC, that can be used by query optimizers to amortize...
Antara Ghosh, Jignashu Parikh, Vibhuti S. Sengar, ...