Sciweavers

Share
SIGMOD
2009
ACM

Interactive plan hints for query optimization

9 years 10 months ago
Interactive plan hints for query optimization
Commercial database systems expose query hints to fix poor plans produced by the query optimizer. However, current query hints are not flexible enough to deal with a variety of non-trivial scenarios, and can be at times cumbersome for DBAs to interact with. In this demonstration we present a framework that enables visual specification of hints to influence the optimizer to pick better plans. Our framework goes considerably beyond existing hinting mechanisms and significantly improves the usability of such functionality. Categories and Subject Descriptors H.2.7 [Database Administration] General Terms Algorithms, Design Keywords Query Hinting, Query Optimization
Nicolas Bruno, Surajit Chaudhuri, Ravishankar Rama
Added 05 Dec 2009
Updated 05 Dec 2009
Type Conference
Year 2009
Where SIGMOD
Authors Nicolas Bruno, Surajit Chaudhuri, Ravishankar Ramamurthy
Comments (0)
books