On Saying "Enough Already!" in SQL
Summary: SQL extension to explicitly bound query result cardinality. Examines optimizer and run-time impact; proposes Conservative and Aggressive approaches to exploiting cardinality limits in relational plans, with a DB2-based empirical study showing benefits and tradeoffs. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Michael J. Carey (IBM)
- 2. Donald Kossmann (IBM; University of Passau)
BibTeX Citation
@inproceedings{carey_sigmod97,
title = {{On Saying "Enough Already!" in SQL}},
author = {Carey, Michael J. and Kossmann, Donald},
series = {{SIGMOD} '97},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/253260.253302},
url = {https://dl.acm.org/doi/10.1145/253260.253302},
year = {1997}
}Incoming Citations (Sorted by Pagerank)
Showing 44 of 44 citing papers.
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 8 of 8 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 |
| 71 | Including Group-By in Query Optimization | 1994 | VLDB | 0.00038021159 |
| 119 | The EXODUS Optimizer Generator | 1987 | SIGMOD | 0.0003183602 |
| 170 | Combining Fuzzy Information from Multiple Systems | 1996 | PODS | 0.00027376361 |
| 192 | Grammar-like Functional Rules for Representing Query Optimization Alternatives | 1988 | SIGMOD | 0.00026028406 |
| 434 | Query Optimization for Parallel Execution | 1992 | SIGMOD | 0.00018531826 |
| 675 | Optimizing Queries over Multimedia Repositories | 1996 | SIGMOD | 0.00015080025 |
| 744 | Fundamental Techniques for Order Optimization | 1996 | SIGMOD | 0.00014411295 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 664 | Exploiting Statistics on Query Expressions for Optimization | 2002 | SIGMOD |
| 2 | 1,860 | Querying Multiple Features of Groups in Relational Databases | 1996 | VLDB |
| 3 | 10,891 | Cardinality Estimation for Having-Clauses | 2025 | VLDB |
| 4 | 5,863 | Supporting Time-Constrained SQL Queries in Oracle | 2007 | VLDB |
| 5 | 12,289 | Efficient Implementation of Generalized Quantification in Relational Query Languages | 2013 | VLDB |
| 6 | 3,426 | Exact Cardinality Query Optimization for Optimizer Testing | 2009 | VLDB |
| 7 | 5,010 | Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server | 2023 | VLDB |
| 8 | 5,137 | Exact Cardinality Query Optimization with Bounded Execution Cost | 2019 | SIGMOD |
| 9 | 7,495 | On the Calculation of Optimality Ranges for Relational Query Execution Plans | 2018 | SIGMOD |
| 10 | 1,544 | Reducing the Braking Distance of an SQL Query Engine | 1998 | VLDB |