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: 4202
Venue: SIGMOD
Year: 2009
Pagerank: 4.7302233e-05
Overall Rank: 7,440 | 48.25%
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,127	Guided automated learning for query workload re-optimization	2019	VLDB	4.8230386e-05
9,710	QO-Insight: Inspecting Steered Query Optimizers	2023	VLDB	4.299267e-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
790	Exploiting Statistics on Query Expressions for Optimization	2002	SIGMOD	0.0001663283
4,348	Identifying Robust Plans through Plan Diagram Reduction	2008	VLDB	6.2660237e-05
8,111	Databases will Visualize Queries too*	2011	VLDB	4.5842786e-05
4,099	Implementing an Interpreter for Functional Rules in a Query Optimizer	1988	VLDB	6.4545871e-05
9,710	QO-Insight: Inspecting Steered Query Optimizers	2023	VLDB	4.299267e-05
5,340	Efficiently Approximating Query Optimizer Plan Diagrams	2008	VLDB	5.5623066e-05
9,623	Qr-Hint: Actionable Hints Towards Correcting Wrong SQL Queries	2024	SIGMOD	4.3161663e-05
5,264	SeeDB: Visualizing Database Queries Efficiently	2014	VLDB	5.597302e-05
1,070	Analyzing Plan Diagrams of Database Query Optimizers	2005	VLDB	0.00014316791
10,808	Hint-QPT: Hints for Robust Query Performance Tuning	2025	VLDB	4.1945683e-05