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.

PDF file


Publisher  Association for Computing Machinery, Inc.
Copyright © 2007 by the Association for Computing Machinery, Inc. Permission to make digital or hard copies of part or all of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, to republish, to post on servers, or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from Publications Dept, ACM Inc., fax +1 (212) 869-0481, or The definitive version of this paper can be found at ACM’s Digital Library --


> Publications > Interactive Plan Hints for Query Optimization