Interactive Plan Hints for Query Optimization

Summary: Interactive visual hints to steer the optimizer toward better plans. Demonstration shows a framework for visually specifying hints, far surpassing traditional hinting flexibility and usability, enabling DBAs to handle non-trivial scenarios. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 4203
Venue: SIGMOD
Year: 2009
Pagerank: 4.7256896e-05
Overall Rank: 7,438 | 48.31%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
7,126	Guided automated learning for query workload re-optimization	2019	VLDB	4.8184704e-05
9,709	QO-Insight: Inspecting Steered Query Optimizers	2023	VLDB	4.2951473e-05

Outgoing Citations (Sorted by Pagerank)

Showing 0 of 0 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
786	Exploiting Statistics on Query Expressions for Optimization	2002	SIGMOD	0.00016624743
4,342	Identifying Robust Plans through Plan Diagram Reduction	2008	VLDB	6.2680535e-05
8,115	Databases will Visualize Queries too*	2011	VLDB	4.5800219e-05
4,093	Implementing an Interpreter for Functional Rules in a Query Optimizer	1988	VLDB	6.4521318e-05
9,709	QO-Insight: Inspecting Steered Query Optimizers	2023	VLDB	4.2951473e-05
5,344	Efficiently Approximating Query Optimizer Plan Diagrams	2008	VLDB	5.5579641e-05
9,623	Qr-Hint: Actionable Hints Towards Correcting Wrong SQL Queries	2024	SIGMOD	4.3120302e-05
5,263	SeeDB: Visualizing Database Queries Efficiently	2014	VLDB	5.5959099e-05
1,064	Analyzing Plan Diagrams of Database Query Optimizers	2005	VLDB	0.00014348262
10,813	Hint-QPT: Hints for Robust Query Performance Tuning	2025	VLDB	4.1905499e-05