Interactive plan hints for query optimization

Authors:
Nicolas Bruno;Surajit Chaudhuri;Ravishankar Ramamurthy
Affiliations:
Microsoft Research, Redmond, WA, USA;Microsoft Research, Redmond, WA, USA;Microsoft Research, Redmond, WA, USA
Venue:
Proceedings of the 2009 ACM SIGMOD International Conference on Management of data
Year:
2009

Citing 2
Cited 2

Implications of certain assumptions in database performance evauation

ACM Transactions on Database Systems (TODS)
Power Hints for Query Optimization

ICDE '09 Proceedings of the 2009 IEEE International Conference on Data Engineering

True language-level SQL debugging

Proceedings of the 14th International Conference on Extending Database Technology
Observing SQL queries in their natural habitat

ACM Transactions on Database Systems (TODS)

Quantified Score

Hi-index	0.00

Visualization

Abstract

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.