cockroachdb / cockroachdb/cockroach
sql: add option to disable limit hint propagation
Open
C-enhancement
E-quick-win
O-support
P-3
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
As seen in issues like #84461 and #85561, limit hints, or soft limits, can lead to poorly performing query plans. We should offer users an option to disable propagation of limit hints to give them a workaround for this.
Jira issue: CRDB-30055
Contributor guide
Assessment
This issue has not been assessed yet.