The Value of Merge-Join and Hash-Join in SQL Server
Summary: Evaluates the incremental value of merge-join and hash-join in SQL Server for OLTP and DSS workloads using an internal build and TPC-D experiments. Shows that OLTP workloads need only nested loops, while delivering optimal decision-support performance requires both merge-join and hash-join. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Goetz Graefe (Microsoft)
BibTeX Citation
@article{graefe_vldb99,
title = {{The Value of Merge-Join and Hash-Join in SQL Server}},
author = {Graefe, Goetz},
journal = {PVLDB},
series = {{VLDB} '99},
year = {1999}
}Incoming Citations (Sorted by Pagerank)
Showing 3 of 3 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 184 | DB2 Design Advisor: Integrated Automatic Physical Database Design | 2004 | VLDB | 0.00026256101 |
| 600 | Rethinking Database System Architecture: Towards a Self-tuning RISC-style Database System | 2000 | VLDB | 0.00015871387 |
| 1,567 | Fractal Prefetching B+-Trees: Optimizing Both Cache and Disk Performance | 2002 | SIGMOD | 0.00010343873 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 4 of 4 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1 | Access Path Selection in a Relational Database Management System | 1979 | SIGMOD | 0.0024089429 |
| 7 | Implementation Techniques For Main Memory Database Systems | 1984 | SIGMOD | 0.00083340894 |
| 1,809 | Hash joins and hash teams in Microsoft SQL Server | 1998 | VLDB | 9.7034998e-05 |
| 1,870 | Microsoft Index Tuning Wizard for SQL Server 7.0 | 1998 | SIGMOD | 9.579726e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 5,443 | Generalized Hash Teams for Join and Group-by | 1999 | VLDB |
| 2 | 252 | Multi-Core, Main-Memory Joins: Sort vs. Hash Revisited | 2014 | VLDB |
| 3 | 1,740 | Adopting Worst-Case Optimal Joins in Relational Database Systems | 2020 | VLDB |
| 4 | 242 | A Performance Evaluation of Four Parallel Join Algorithms in a Shared-Nothing Multiprocessor Environment | 1989 | SIGMOD |
| 5 | 360 | Design and Evaluation of Main Memory Hash Join Algorithms for Multi-core CPUs | 2011 | SIGMOD |
| 6 | 2,470 | Hash-Based Join Algorithms for Multiprocessor Computers with Shared Memory | 1990 | VLDB |
| 7 | 904 | Tradeoffs in Processing Complex Join Queries via Hashing in Multiprocessor Database Machines | 1990 | VLDB |
| 8 | 209 | Sort vs. Hash Revisited: Fast Join Implementation on Modern Multi-Core CPUs | 2009 | VLDB |
| 9 | 3,011 | Design and Evaluation of Parallel Pipelined Join Algorithms | 1987 | SIGMOD |
| 10 | 1,809 | Hash joins and hash teams in Microsoft SQL Server | 1998 | VLDB |