Extreme Visualisation of Query Optimizer Search Spaces
Summary: Visualizes dynamic SQL Anywhere optimizer search spaces, showing how cost-based and heuristic decisions shape access plans. Logs compact search-space traces and compares single vs cross-run spaces, enabling performance diagnosis without a live server. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
No non-self incoming citations found for this paper in this database.
Authors
- 1. Anisoara Nica (Sybase)
- 2. Daniel Scott Brotherston (University of Waterloo)
- 3. David William Hillis (University of Waterloo)
BibTeX Citation
@inproceedings{nica_sigmod09,
title = {{Extreme Visualisation of Query Optimizer Search Spaces}},
author = {Nica, Anisoara and Brotherston, Daniel Scott and Hillis, David William},
series = {{SIGMOD} '09},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/1559845.1559983},
url = {https://dl.acm.org/doi/10.1145/1559845.1559983},
year = {2009}
}Incoming Citations (Sorted by Pagerank)
Showing 0 of 0 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|
Previous
Page 1 / 1
Next
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 |
|---|
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 10,834 | QOVIS: Understanding and Diagnosing Query Optimizer via a Visualization-assisted Approach | 2025 | VLDB |
| 2 | 839 | Query Optimization by Simulated Annealing | 1987 | SIGMOD |
| 3 | 9,846 | QO-Insight: Inspecting Steered Query Optimizers | 2023 | VLDB |
| 4 | 1,604 | The Picasso Database Query Optimizer Visualizer | 2010 | VLDB |
| 5 | 4,817 | Efficiently Approximating Query Optimizer Plan Diagrams | 2008 | VLDB |
| 6 | 290 | An Overview of Query Optimization in Relational Systems | 1998 | PODS |
| 7 | 2,582 | On the Effectiveness of Optimization Search Strategies for Parallel Execution Spaces | 1993 | VLDB |
| 8 | 7,448 | Interactive Plan Hints for Query Optimization | 2009 | SIGMOD |
| 9 | 7,098 | QueryScope: Visualizing Queries for Repeatable Database Tuning | 2008 | VLDB |
| 10 | 5,329 | SeeDB: Visualizing Database Queries Efficiently | 2014 | VLDB |