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

• Type: Conference
• Year: 2009
• Where: SIGMOD
• Authors: Nicolas Bruno, Surajit Chaudhuri, Ravishankar Ramamurthy
• Keywords: Current Query Hints, Database, Query Optimizer, SIGMOD 2009, Systems Expose Query