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.0023943337 |
| 73 | Including Group-By in Query Optimization | 1994 | VLDB | 0.0003750677 |
| 118 | The EXODUS Optimizer Generator | 1987 | SIGMOD | 0.00031381726 |
| 172 | Combining Fuzzy Information from Multiple Systems | 1996 | PODS | 0.00026824625 |
| 196 | Grammar-like Functional Rules for Representing Query Optimization Alternatives | 1988 | SIGMOD | 0.00025616489 |
| 446 | Query Optimization for Parallel Execution | 1992 | SIGMOD | 0.00018167535 |
| 686 | Optimizing Queries over Multimedia Repositories | 1996 | SIGMOD | 0.00014769852 |
| 725 | Fundamental Techniques for Order Optimization | 1996 | SIGMOD | 0.00014471289 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 644 | Exploiting Statistics on Query Expressions for Optimization | 2002 | SIGMOD |
| 2 | 1,899 | Querying Multiple Features of Groups in Relational Databases | 1996 | VLDB |
| 3 | 11,298 | Cardinality Estimation for Having-Clauses | 2025 | VLDB |
| 4 | 5,983 | Supporting Time-Constrained SQL Queries in Oracle | 2007 | VLDB |
| 5 | 12,586 | Efficient Implementation of Generalized Quantification in Relational Query Languages | 2013 | VLDB |
| 6 | 3,362 | Exact Cardinality Query Optimization for Optimizer Testing | 2009 | VLDB |
| 7 | 5,020 | Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server | 2023 | VLDB |
| 8 | 5,200 | Exact Cardinality Query Optimization with Bounded Execution Cost | 2019 | SIGMOD |
| 9 | 7,603 | On the Calculation of Optimality Ranges for Relational Query Execution Plans | 2018 | SIGMOD |
| 10 | 1,574 | Reducing the Braking Distance of an SQL Query Engine | 1998 | VLDB |